Delete Formula

A

azazel

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
 
P

Per Erik Midtrød

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
 
Top