Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bakee
 
Posts: n/a
Default 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
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to merge data from multiple columns to one column w8ting4hlp Excel Discussion (Misc queries) 5 October 9th 08 08:44 PM
How to convert columns of data to one column of text devlkat Excel Worksheet Functions 3 April 6th 05 04:08 PM
merge data from multiple columns to single column triggerthehorse Excel Worksheet Functions 2 January 17th 05 07:19 PM
Data from a number of rows and columns to one column mark_h82 Excel Discussion (Misc queries) 2 January 15th 05 03:02 AM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM


All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"