Discussion Locked

Extracting Values in Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

After reading the article on using excels right, left and mid string utility my life has been easier. However i am never happy as i have a series of alphanumeric entries in excel and i would like to know if thers is a formulae to take off the end *no. of characters.
e.g.
EXAMPLE(123)
EXAMPLE(234)
EXAMPLES(123)
using the left string function i can extract a certain number of figures from the left, however what would really be useful was if i could delete the last three characters of each cell.
I hope i managed to explain myself correctly and if anyone could help i would be greatful.

2 replies

by jim_rau

Well of course you can do that ... using the LEN function to determine the number of characters in a string.

If cell A1 has a text value you can put the name minus the last three characters in cell B1 with this formula
=LEFT(A1,LEN(A1)-3)

LEN(A1) will return the number of characters in the string (whatever it may be).

Good luck on your project ... I hope this helps!

This discussion is closed to new replies.