Forum Home
Press F1
 
Thread ID: 2844 1999-10-25 22:40:00 Combining column text in MS Excel 97 Guest (0) Press F1
Post ID Timestamp Content User
3255 1999-10-25 22:40:00 Hi
I am desperate to find out how to combine text from two neighbouring columns in Excel 97. ie; If I have a number '1' in column A and the word 'way' in column B (on the same row)- is there a way to select this data and merge it into ONE column so it would now read '1 way'.
I have searched all the help lists with no luck. I know this can be done, could it have something to do with saving as a .csv or special type of file to format the columns??
Graeme
Guest (0)
1