On Oct 17, 9:17*pm, barry houdini <barry.houdini.
wrote:
Another formula option
=REPLACE(A1,1,FIND("@",A1),"")
--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile:http://www.thecodecage.com/forumz/member.php?userid=72
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=145311
Thank You all for your assistance problem has been solved