I am trying to pick up the last 7 character into a new adjacent column, but I DONT KNOW HOW could someone help please?
Regards
tropezfn
I am trying to pick up the last 7 character into a new adjacent column, but I DONT KNOW HOW could someone help please?
Regards
tropezfn
Hello,Originally Posted by tropezfn
Not quite sure what you mean, I'm assuming that you want to extract the last 7 characters from the adjacent column, if so try this, again assuming your data is in A1
=RIGHT(A1,7)
oldchippy![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks