| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to combine contents from 2 cells into 1
Ex: Row 1 would have first name "John" and row 2 would have last name "Doe"
Now what I need is Row 3 to have from row 1 only first letter from the name and from row 2 the full lastname. I know how to combine the 2 rows but not to only get the first letter. Result should be JDoe in row 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting contents of cells in non contiguous ranges | Excel Worksheet Functions | |||
| copying part of a cell's contents (formatted as dd:hh:mm) | Excel Worksheet Functions | |||
| How to let excel cells width fixed and automatically wrap the contents | Excel Discussion (Misc queries) | |||
| how to combine including blank cells | New Users to Excel | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Linear Mode
