| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying selected contents in one cell to another cell
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!!!!!!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying selected contents in one cell to another cell
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!!!!!!!! "Per Jessen" wrote: 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!!!!!!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying selected contents in one cell to another cell
Try this:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99), LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1),99)) The Needy wrote: 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!!!!!!!! "Per Jessen" wrote: 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!!!!!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
| Copying cell contents from many cells and pasting into one cell | Excel Discussion (Misc queries) | |||
| Transferring cell contents from selected rows only. | Excel Worksheet Functions | |||
| Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) | |||
| print only selected cell contents without loosing spread sheet for | Excel Discussion (Misc queries) | |||
Linear Mode
