row c contains cells each with a series of numbers and a letter on the end. What I would like to do is, in column D have the lletter contained the the correspnding cell C placed there on its own eg
12345H H
456789D D
23459E E
Great if anyone can help me on this.
Last edited by langdon37; 11-13-2008 at 09:32 AM.
Hi,
If your data is in C1,
=RIGHT(C1,1)
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Try...
=RIGHT(C2,1)
Hope this helps!
If the letter is always the last character in the cell...
try this:
Is that something you can work with?B1: =RIGHT(A1,1)
Thanks everyone will give it a go.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks