Copying selected contents in one cell to another cell

  • Thread starter Thread starter The Needy
  • Start date Start date
T

The Needy

I've been given a list of names (first, middle, and last) in one column and
on another column, I need to put together the first and middle names only
without typing it out and using a function, but I don't know what function to
use. Please help me!!!!!!!!! I need to know ASAP!!!!!!!!!! THANK YOU IN
ADVANCE!!!!!!!!!
 
Sorry, I don't think that's it, Per.

Here is how it looks like:

Column A Column B

Smith John D (need only first and middle name)



Thank you!!!!!!!!
 
Try this:

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99),
LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1),99))
 
Hi Needy,

=LEFT(A1,FIND("~",SUBSTITUTE(A1," ","~",2),1)-1)

Because there is more than one space, and FIND will only help to find the
first instance of space - the SUBSTITUTE function allows you to replace a
subsequent instance of a character with another character. The rule is that
the character used should be unique - hopefully the tilde is unique to your
data.

Thanks,
Peggy
 
Back
Top