try using replace "smith" with ""

--
Don Guillett
SalesAid Software

"azazel" wrote in
message ...

Cell A1 = Betty Smith
Cell B1 = Smith

I need a formula that will delete Smith from cell A1, using cell B1 as
the reference...

Column A ____ ; B ; Formula
1 Betty Smith ; Smith ; =Betty
2 Jim Jones ; Jones ; =Jim
3 Sam Stone ; Stone ; =Sam


--
azazel
------------------------------------------------------------------------
azazel's Profile:
http://www.excelforum.com/member.php...o&userid=28250
View this thread: http://www.excelforum.com/showthread...hreadid=482914