I have tried to split the cell though it it removes all S's in words, I only require the last letters in a new cell. IE XS, L, M, S etc and all words are not the same length.
Not so up with formulas or can it done easily with Text to columns?
Sammy Dress Porcini XS
Amelia Cowl Jacket
Billie Blouse L
Billie Blouse L
Billie Blouse M
Billie Blouse S
Billie Blouse XS
Cheers
you could try something like this
Formula:
TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",50)),50))
if you want to control as in-> Amelia Cowl Jacket
you can use
Formula:=IF(LEN(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",50)),50)))>3,"",TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",50)),50)))
if letters exceeds 3 characters return blank.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi and welcome to the forum
Assuming your data is in A1 down, you could also give this a try, copied down...
=MID(A1,SEARCH("xxx",SUBSTITUTE(A1," ","xxx",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),1)+1,99)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks