View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Copying selected contents in one cell to another cell

Hi

With data in A1:C1 use this formula:

=A1 & " " & B1

Regards,
Per

"The Needy" <The skrev i meddelelsen
...
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!!!!!!!!!