Thread: Formula Help
View Single Post
  #3  
Old May 28th, 2010, 05:15 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
  
Posts: 1,245
Default Formula Help
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


=MID(A1,FIND("_",A1)+1,LEN(A1))