Hi
Iam trying to extract all but the last two words in a variable length string.
The last two words are a constant length both 9 digits long.
I have attached a sample spreadsheet.
How can I do this?
macke
Hi
Iam trying to extract all but the last two words in a variable length string.
The last two words are a constant length both 9 digits long.
I have attached a sample spreadsheet.
How can I do this?
macke
try to use this
=left(A2,len(A2)-20)
but this:must be the trueboth 9 digits long
Last edited by tom1977; 12-12-2011 at 07:12 AM.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Brilliant thank you. it works perfectly.
macke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks