Trim characters

  • Thread starter Thread starter Ronbo
  • Start date Start date
R

Ronbo

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
 
Never mind. I had it all the time but the cell format was only showing 4
characters.

Ronbo
 
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)
 
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?
 
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
 
Back
Top