| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coping part of a cell content into a seperate cell
Hi
I have two cells, one containing first and middle name and another one with surname. I want to combine the first name and surname into a separate cell, can you advise how I can just copy the first name and miss out the middle name please?? Thanks Caz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coping part of a cell content into a seperate cell
Hi,
I assume that the midle name is separated by a space from the first name and is in column A and the last name in column B =TRIM(LEFT(A2,FIND(" ",a2)-1))&" "&B2 "Caz H" wrote: Hi I have two cells, one containing first and middle name and another one with surname. I want to combine the first name and surname into a separate cell, can you advise how I can just copy the first name and miss out the middle name please?? Thanks Caz |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coping part of a cell content into a seperate cell
Hi Caz, I assume not everyone will have a middle name, try something like:
=IF(ISERROR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))&" "&B1 Where the forename is in cell A1 and the surname is in cell A2. Hth Stu "Caz H" wrote: Hi I have two cells, one containing first and middle name and another one with surname. I want to combine the first name and surname into a separate cell, can you advise how I can just copy the first name and miss out the middle name please?? Thanks Caz |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coping part of a cell content into a seperate cell
...........That should read - the surname is in cell B1!
"stumac" wrote: Hi Caz, I assume not everyone will have a middle name, try something like: =IF(ISERROR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))&" "&B1 Where the forename is in cell A1 and the surname is in cell A2. Hth Stu "Caz H" wrote: Hi I have two cells, one containing first and middle name and another one with surname. I want to combine the first name and surname into a separate cell, can you advise how I can just copy the first name and miss out the middle name please?? Thanks Caz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use the content of a cell as part of filereference in other | Excel Worksheet Functions | |||
| display part of the cell content | Excel Discussion (Misc queries) | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| Can I search a cell for a value and extract part of content? | Excel Discussion (Misc queries) | |||
| vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
![Caz H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
