trim everything from left of first underscore in the text?
Try this:
=RIGHT(A1,LEN(A1)-SEARCH("_",A1))
Hope this helps.
Pete
On Jul 28, 7:24*pm, "Mitchell_Collen via OfficeKB.com" <u33726@uwe
wrote:
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 viahttp://www.officekb.com
|