Delete Formula
 

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

Delete Formula
 

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

Delete Formula
 

I think you could use this formula:
=REPLACE(A1;FIND(B1;A1);LEN(B1);"")

It works like this:
replace the value in A1 with "" starting at the position where it
finds B1. It might be easier to understand if you just try it.

Per Erik



On Mon, 7 Nov 2005 13:57:28 -0600, azazel
wrote:


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