Excel 2007 : Right & Search combo

**benoj2005** · 05-10-2012, 09:52 AM

Hi

I basically want to search for "-" from the right of a cell and take anything after the "-" (Not including the -)

See attached basic example. I've tried a whole host of search and right combos and don't seem to be getting what I need!!

Thanks

Right and search function.xlsx

**Russell Dawson** · 05-10-2012, 09:58 AM

Is the format always the same irrespective of number of characters? i.e. Characters Dash Characters Dash Characters

Text to columns would do it.

**benoj2005** · 05-10-2012, 10:08 AM

Text to columns would be messy.

There may be 1-2, 1-2-3, 1-2-3-4, 1-2-3-4-5 . I'm only interested in the information after the last "-".

If I was to use text to columns I would be hunting in different columns for this info?

The simple way is to search from the end of the text string surely?

**Russell Dawson** · 05-10-2012, 10:29 AM

Try this

http://www.excelforum.com/excel-work...in-a-cell.html

Post number 2 did it for me.

**benoj2005** · 05-14-2012, 06:02 AM

Originally Posted by Russell Dawson

Try this

http://www.excelforum.com/excel-work...in-a-cell.html

Post number 2 did it for me.

Cheers

=REPLACE(A2,1,LOOKUP(2^15,FIND("-",A2,ROW(INDIRECT("1:"&LEN(A2))))),"")

Worked a treat as per attached Right and search function.xlsx

I'm trying to workout how it works! I can't get my head round it, if anyone would like to break it down that would be great