| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merging 2 cells and adding a space.
I want to merge 2 cells into 1 and add a space.
for example I have this: A1 = Tim B1 = Smith I want to make either A1 = Tim Smith or C1 = Tim Smith How would I do this? I have tried text to column with not much luck |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merging 2 cells and adding a space.
You can't do it in A1 without using VB... you can't have a formula and a
text constant in the same cell. You can do it in C1 though... =A1&" "&B1 -- Rick (MVP - Excel) "paul" wrote in message ... I want to merge 2 cells into 1 and add a space. for example I have this: A1 = Tim B1 = Smith I want to make either A1 = Tim Smith or C1 = Tim Smith How would I do this? I have tried text to column with not much luck |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging spreadsheets/one has extra space in each cell | Excel Discussion (Misc queries) | |||
| Adding a space | Excel Worksheet Functions | |||
| how do you add a space when merging text using & ? | Excel Discussion (Misc queries) | |||
| Adding a space in text | Excel Worksheet Functions | |||
| Adding a space with =A59&B59 | Excel Worksheet Functions | |||
Linear Mode
