MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Parsing out data to the right of a piece of data


Posted by Jonathan McGuire on October 03, 2001 10:15 AM

Hello Folks!

I give up! I need to parse out a cell that contains a / on the text. I need to return all the text to the right of the / in the field. The issue is that it is not always in the same place or not at all.

Thanks in advance for your time and expertise.

Respectfully,

Jonathan McGuire


Posted by Aladin Akyurek on October 03, 2001 10:18 AM

=RIGHT(A1,LEN(A1)-SEARCH("/",A1)). (NT)

Posted by Aladin Akyurek on October 03, 2001 10:22 AM

By the way...

I didn't take in to account that "not at all part". So use instead:

=IF(ISNUMBER(SEARCH("/",A1)),RIGHT(A1,LEN(A1)-SEARCH("/",A1)),A1)

Aladin

======

Posted by Barrie Davidson on October 03, 2001 10:24 AM

You could also..

select Data|TexttoColumns, and select "Delimited" file type. You could then specify "/" as the delimiter.

BarrieBarrie Davidson

Posted by Jonathan McGuire on October 03, 2001 10:28 AM

Re: You could also..

Thanks for your tip Barrie-this will come in handy!

Sincerely,

Jonathan

Posted by Jonathan McGuire on October 03, 2001 10:29 AM

Re: By the way...

Hey Aladin! Great work. Thanks for your time and patience. This will save much time-

Regards,

Jonathan