Trim characters

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
 
R

Ronbo

Never mind. I had it all the time but the cell format was only showing 4
characters.

Ronbo
 
O

OssieMac

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)
 
R

Rick Rothstein

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?
 
R

Ronbo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula help 2
Using Trim with wildcards possible? 1
Restricting Number of characters in a cell 9
Removing text in combo with anther FIND function 4
Remove non-space spaces? 3
Len & Trim Function 6
TRIM FUNCTION...how to? 3
Vlookup where table array is in text format 4

Top