Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trim everything from left of first underscore in the text?
Hi,
With your text in a1 try this and drag down =MID(A1,FIND("_",A1)+1,LEN(A1)) Mike "Mitchell_Collen via OfficeKB.com" 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 via http://www.officekb.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trim everything from left of first underscore in the text?
You could use a helper cell with a formula:
=MID(A1,SEARCH("_",A1,1)+1,255) The 255 is just a big number that is large enough to grab all the remaining text. "Mitchell_Collen via OfficeKB.com" 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 via http://www.officekb.com -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trim everything from left of first underscore in the text?
Thanks so very much! Your solution did the job!
-M -- Misty :-) Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
underscore in email address covered by hyperlink underscore | Excel Discussion (Misc queries) | |||
TRIM, LEFT, RIGHT | Excel Worksheet Functions | |||
left trim | Excel Worksheet Functions | |||
Splitting 1 cell into 2 based on underscore in text | Excel Worksheet Functions | |||
text trim combine | Excel Discussion (Misc queries) |