Windows XP Combining Cells

C

c mcg

Joined
Apr 17, 2006
Messages
1
Reaction score
0
I have a spreadsheet that has information on people in it. columns A to C have a name broken down into 3 sections consisting of a title, first name and surname. I then have in columns G, H, and I which is an address that is broken into 3 sections consisting of door number, street name and town.

I have to combine the data in these cells so that all information goes into one cell. The thing is I have a spreadsheet of around 200 rows and i need to run this on each row.

I previously had a macro to do this for me that a friend of mine who i can no longer contact created for me but when i upgraded my computer i lost it. as far as i know the macro moved any highlighted cells data to the first highlighted column.

Sorry to be a bit vague any help is appreciated
wink.gif
 
If you want the info to go in column J then use this code in cell J1 (or whichever cell you want to start in):

Code: 
=(A1&" "&B1&" "&C1&" "&G1&" "&H1&" "&I1)

That should do it. It'll combine all of that data in each of those cells with a space in bewteen each piece of data. Then simply place youre cursor on the bottom right corner of that cell and drag the formula down 200 rows. It'll only take a few seconds :thumb: . If you need a macro to copy it down I'll need a little more time to get one for you. I can do it (there's more than one way) but I don't use M$ Office at home anymore and I would have to find time at work to come up with one :)
 
Back
Top