| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to combine text from 3 cells into 1 cell with space and ", bet
How to combine text from 3 cells into 1 cell with space and ", between. Is it
a formala I can use? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to combine text from 3 cells into 1 cell with space and ", bet
HI
Try this =A1&" "&""""&B1&" "&""""&C1, adjust range to your needs HTH John "JOF" wrote in message ... How to combine text from 3 cells into 1 cell with space and ", between. Is it a formala I can use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate Text from a cell by space into other cells | Excel Worksheet Functions | |||
| How do I put a "hard space" into text in a excel 2007 cell? | Excel Discussion (Misc queries) | |||
| How to combine multiple rows of text cells into one cell | Excel Discussion (Misc queries) | |||
| "Wrap text" makes row larger than text resulting in white space. | Excel Discussion (Misc queries) | |||
| How to combine 2 cells' text into 1 cell | Excel Discussion (Misc queries) | |||
Linear Mode
