LinkBack URL
About LinkBacks
Morning all,
Hopefully a quick and simple one. How can I extract the text that comes before one of two keywords ('Full' & 'YTD') and remove the trailing space? Example attached.
Thanks in advance,
Snook
Morning all,
Hopefully a quick and simple one. How can I extract the text that comes before one of two keywords ('Full' & 'YTD') and remove the trailing space? Example attached.
Thanks in advance,
Snook
Hi,
=TRIM(LEFT(B4,MIN(SEARCH({"Full","YTD"},B4&"FullYTD")-1)))
Regards
Hi XOR LX,
That's not quite bringing back what I was looking for. For example the first cell returns "Dept F" when I would expect it to return "Dept".
Edit: Did you tweak your solution because it works now?!?!
Cheers,
Snook
Ah, sorry. Should've said something. Thought I'd 'tweaked' it in time for you not to notice! You were too quick! :-)Originally Posted by The_Snook
Hi XOR LX,
That's not quite bringing back what I was looking for. For example the first cell returns "Dept F" when I would expect it to return "Dept".
Edit: Did you tweak your solution because it works now?!?!
Cheers,
Snook
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks