View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mitchell_Collen via OfficeKB.com Mitchell_Collen via OfficeKB.com is offline
external usenet poster
 
Posts: 27
Default trim everything from left of first underscore in the text?

Hi
I am trying to remove all characters to the left of the first occurence of an
underscore but have not found a good solution. do you know how to do this?
thanks in advance - M

I have test in columns like this:

date_123232_5.txt
date234._2343453_356.txt

I want it to look like this:

123232_5.txt
2343453_356.txt

these will later be transformed to hyperlinks to the exact file.

--
Misty :-)

Message posted via http://www.officekb.com