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

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

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

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

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

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

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

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