remove a name

G

George A. Yorks

have a column of names, first and last. would like a formula that will allow
me to remove either the first or last names from this list.
 
M

Michael

assuming there is a space after each name you could use data> text to columns
and choose the delimited option and select space as the separator
 
R

RichardSchollar

A specific formula option (assuming a space as a delimiter) would be:

=TRIM(LEFT(A1,FIND(" ",A1)))

and

=TRIM(MID(A1,FIND(" ",A1),255))

Hope this helps!

Richard
 
G

George A. Yorks

Richard,

Guess I am more computer illiterate than I thought. I tried using this
formula with no success I used the formula on the same row as the name. Is
that correct
 
Top