ExcelBanter - How to add data in two columns in to one column

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to add data in two columns in to one column (https://www.excelbanter.com/excel-worksheet-functions/28101-how-add-data-two-columns-one-column.html)

bakee

How to add data in two columns in to one column

I want the data in two columns need to be in one column without lossing data

Duke Carey

If it's text values,

=A1&B1

or, if you want a space between them

=A1&" "&B1

"bakee" wrote:

I want the data in two columns need to be in one column without lossing data

All times are GMT +1. The time now is 01:50 AM.