How to add data in two columns in to one column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the data in two columns need to be in one column without lossing data
 
If it's text values,

=A1&B1

or, if you want a space between them

=A1&" "&B1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Comparing two columns 1
Compare identifier columns from 2 sheets - remove rows that are dups 2
Excel Help to copy information from one row at a time to another sheet 1
Really need some help with a multi conditional SumProduct 1
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula to choose from the last column of a given row 1

Back
Top