Copying selected contents in one cell to another cell

[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!!!!!!!!!

 

[Per Jessen]

Hi

With data in A1:C1 use this formula:

=A1 & " " & B1

Regards,
Per

 

[Simon Lloyd]

This should do what you want
=IF(ISERROR(FIND(".",A1,1)),LEFT(A1,LEN(A1)-FIND(
",A1,1)),LEFT(A1,LEN(A1)-FIND(".",A1,1)-1)

I've been given a list of names (first, middle, and last) in one colum
an
on another column, I need to put together the first and middle name
onl
without typing it out and using a function, but I don't know wha
function t
use. Please help me!!!!!!!!! I need to know ASAP!!!!!!!!!! THANK YOU I
ADVANCE!!!!!!!!

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[The Needy]

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

 

[Simon Lloyd]

This will do it
=IF(ISERROR(FIND(".",A1,1)),LEFT(A1,LEN(A1)-FIND(
",A1,1)),LEFT(A1,LEN(A1)-FIND(".",A1,1)-1)

Sorry, I don't think that's it, Per

Here is how it looks like

Column A Column

Smith John D (need only first and middle name



Thank you!!!!!!!

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Simon Lloyd]

Sorry that was the wrong formula to paste , try this:
=A1&" "&IF(ISERROR(FIND(".",B1,1)),LEFT(B1,FIND("
",B1,1)-1),LEFT(B1,FIND(".",B1,1)))

This will do it:
=IF(ISERROR(FIND(".",A1,1)),LEFT(A1,LEN(A1)-FIND("
",A1,1)),LEFT(A1,LEN(A1)-FIND(".",A1,1)-1))

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)

 

[The Needy]

Is there a shorter function to do this?

This should do what you want:
=IF(ISERROR(FIND(".",A1,1)),LEFT(A1,LEN(A1)-FIND("
",A1,1)),LEFT(A1,LEN(A1)-FIND(".",A1,1)-1))



--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)

 

[Glenn]

Try this:

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

 

[pshepard]

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