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.
--
George

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

"George A. Yorks" wrote:

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.
--
George

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


On 15 Mar, 14:02, George A. Yorks .(donotspam)
wrote:
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.
--
George

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
--
George


"RichardSchollar" wrote:

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


On 15 Mar, 14:02, George A. Yorks .(donotspam)
wrote:
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.
--
George