LinkBack URL
About LinkBacks
I have a column of cells that looks something like this...
N 65478 A
O 548731 C
N 89114 B
N 649944 D
O 94331 B
What formula should I use to get just the last character in these cells??? I want to get...
A
C
B
D
B
I have a column of cells that looks something like this...
N 65478 A
O 548731 C
N 89114 B
N 649944 D
O 94331 B
What formula should I use to get just the last character in these cells??? I want to get...
A
C
B
D
B
assuming the first one is in A1 then use---> =right(A1,1)
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
this works! thanks
Your welcome!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks