Hi all,
I want to strip the value of column A up until it finds a '-'
for example
A
UK - Code GUI
UK - Back-end reconstruction
Thailand - Code GUI II
I want to return in column B, the first part of the value in column A,
so
UK
UK
Thailand repsectively.
can anybody show me how to do this?
many thanks,
Matt
With your text in A1, put this in B1
=LEFT(A1,FIND("-",A1,1)-1)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
thanks!
thats great!
Glad it worked for you - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks