ExcelBanter - How to combine text from 3 cells into 1 cell with space and ", bet

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How to combine text from 3 cells into 1 cell with space and ", bet (https://www.excelbanter.com/new-users-excel/220377-how-combine-text-3-cells-into-1-cell-space-bet.html)

JOF

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?

John[_22_]

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?

All times are GMT +1. The time now is 03:54 PM.