Thread
:
Formula Help
View Single Post
#
3
May 28th, 2010, 05:15 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
Posts: 1,245
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))
Glenn[_6_]
View Public Profile
View message headers
Find all posts by Glenn[_6_]
Find all threads started by Glenn[_6_]