Based on your example data the data starts after a space. Use a Helper column with this formula copied down the column:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
Based on your example data the data starts after a space. Use a Helper column with this formula copied down the column:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks