Excel - How do I remove the last character...

[Livia8]

...from a long list of alphanumerical digits? (Apart from the obvious way of clicking on the cell and manually deleting it, of course!)

I've tried to align all the figures on the right and to use "text to columns" to move the last digit to a new column, but this doesn't seem to work because the figures have a different number of charachters and because on the "text to column" function they seem to be aligned on the left.

Here's an example of the cells in column 1:

10405
13552
135X
14508
205
20605
2337X
2340X
23507
3147X
32204
32255
32352
34754
3549
3557
45003Y
450073

I don't mind copying the column to Word and then back to Excel if it makes any difference.

I'm sure there's a very easy solution but I just can't see it... help, please!

Thanks,

Livia

 

[xlbo]

Enter:
=Left(A1,Len(A1)-1)

next to your 1st record (and sub A1 for the cell ref)
copy down
paste as values
et voila

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[rss01]

In Excel I'm assuming these values are in column A.

10405 =LEFT(A1,LEN(A1)-1) returns 1040
10405 =RIGHT(A1,1) returns 5

hopefully this is what you are looking for.

 

[Livia8]

Many thanks to you both, it works like a charm!