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
