i need help how to get last character using excel formula
below is my list
a1.b_12
a2.c_1
abd.c_23
to become
12
1
23
thanks
i need help how to get last character using excel formula
below is my list
a1.b_12
a2.c_1
abd.c_23
to become
12
1
23
thanks
12 is not the last character, it's the last two. Do you mean after _
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If there's always going to be an underline in the text, and just one underline then the formula is (with the original value in cell A1)
=MID(A1,FIND("_",A1")+1,255)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks