MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COMBINING CELLS


Posted by junsport on June 01, 2001 12:35 PM

HOW CAN I COMBINE THE DATA IN ONE COLUMN WITH THE DATA IN ANOTHER ONE????????????


Posted by Uttam on June 01, 2001 12:42 PM

You can use the CONCATENATE function to string up two or more text variables. If you want to string up a numeric value and a string, then convert the numeric value into a text first (by using a TEXT function and then use CONCATENATE

Hope this helps

Posted by Russell on June 01, 2001 1:04 PM

You don't need to convert to text first.

Posted by Loren on June 01, 2001 1:21 PM

COMBINING -even simpler: = cell1 & cell2