| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim characters
I have looked and tried different formulas on the web site but I am not
getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim characters
You didn't tell us what formulae you had tried and in what way they didn't
work. Did you try =RIGHT(A1,LEN(A1)-FIND("-",A1)) ? -- David Biddulph "Ronbo" wrote in message ... I have looked and tried different formulas on the web site but I am not getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim characters
Thank you so much!! This worked great for me!! :) Terry
"David Biddulph" wrote: You didn't tell us what formulae you had tried and in what way they didn't work. Did you try =RIGHT(A1,LEN(A1)-FIND("-",A1)) ? -- David Biddulph "Ronbo" wrote in message ... I have looked and tried different formulas on the web site but I am not getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim characters
Never mind. I had it all the time but the cell format was only showing 4
characters. Ronbo "Ronbo" wrote: I have looked and tried different formulas on the web site but I am not getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim characters
Hi Ronbo,
Do I interpret your question correctly then assuming the string is in A1 try the following:- =MID(A1,FIND("- ",A1,1)+2,255) -- Regards, OssieMac "Ronbo" wrote: I have looked and tried different formulas on the web site but I am not getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim characters
Thanks a lot. I did not get it to work as I stated, and your formula was
perfect. David's seemed to leave an initial space. Thanks to all for the help. Ronbo "OssieMac" wrote: Hi Ronbo, Do I interpret your question correctly then assuming the string is in A1 try the following:- =MID(A1,FIND("- ",A1,1)+2,255) -- Regards, OssieMac "Ronbo" wrote: I have looked and tried different formulas on the web site but I am not getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim characters
Yes, sorry. I didn't spot the space in " ".
My formula would change to =RIGHT(A1,LEN(A1)-FIND("- ",A1)-1) -- David Biddulph "Ronbo" wrote in message ... Thanks a lot. I did not get it to work as I stated, and your formula was perfect. David's seemed to leave an initial space. Thanks to all for the help. Ronbo "OssieMac" wrote: Hi Ronbo, Do I interpret your question correctly then assuming the string is in A1 try the following:- =MID(A1,FIND("- ",A1,1)+2,255) -- Regards, OssieMac "Ronbo" wrote: I have looked and tried different formulas on the web site but I am not getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim characters
Is there always a dash in the cell? If there is a dash in the cell, is it
always the only one? If there are more than one dash in the cell, which one do you want the text after... the first or last one? -- Rick (MVP - Excel) "Ronbo" wrote in message ... I have looked and tried different formulas on the web site but I am not getting what I am looking for. All I need is all characters after "- ". It's got to be simple but I am not finding it. Any help is appreciated. Ronbo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trim Characters Other Than An Empty Space At The End Of A Cell | Excel Worksheet Functions | |||
| Trim hidden characters? | Excel Worksheet Functions | |||
| How do you trim characters? | Excel Worksheet Functions | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| trim a string by specific number of characters | Excel Discussion (Misc queries) | |||
Hybrid Mode
