| 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 |
| 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 | |||
Threaded Mode
