I wouldn't bother with a formula.

Just use DataText to ColumnsDelimited by hyphen.


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 09:00:01 -0700, Nikki
wrote:

I would like to remove every character up to the "_" and retrieve the name to
the right. Can someone please help me with a formulat that would work for me.
00232902_Joe Smith

Thanks