emrillive

ey guys i have a hudge list of contacts i need to sort through and it is driving me crazy having to seperate each individual box and putting them togehter individually. Can anyone help me how i could combine 2 colums together ? in other words column A has the contact list but in between the contacts there are other information that i dont need so i can delete them, so right now i am grabbing the name,phone number and pushing them over into column B and C. once i move the info into column B and C. As i move my way down doing the rest of the contact i have like 8 rows of blank boxes in between each contact, is there a way i can put them together without having to grabbing each box and putting them together?


any help i would appreaciate cause doing this list of 17,000 lines trying to put into one long line of info is drving me crazy.

espelirS2K

Uh... ctrl+c all the info from column C, ctrl+v in to column B, and then delete all then just delete column C completely (since it's just the phone numbers you've already copied in to column B)

emrillive

i dont understand, how is control c gonna combine the contacts together i tried and it just has a moving box.

espelirS2K

Oh read it wrong. Make sure the two columns you want are right next to each other. Select both columns and right click-->format cells-->click the "alignment tap"-->at the bottom check "merge cells"

I think that's the best way to do it.

I guess I don't understand what you want, sorry

Elistan

This sort of thing, perhaps:

Col A --- Col B --- Col C --- Col D
Name --- junk --- phone --- =A1&" "&C1

The "&" function concatenates strings.

magician

[QUOTE=Elistan,Sep 4 2010, 04:05 PM]This sort of thing, perhaps:

Col A

rustywave

did the previous responses answer your question? if not maybe you can type an example of 2 or 3 lines. cuz from i read it sounds like either what the other guys suggested or maybe you need to use the split function (all info in and only in column a?)...can't really tell.

emrillive

i cant get a diagram on here it just outs everything together and looks like jibberish.

basically lets say i have 1 column. we will call that column A. and i have 5 lines in column A. i have info on line 1 and line 3 and 5. how do i take the info on lines 1,3,5 to go to lines 1,2,3?

magician

You can highlight column A and use the Sort function. That risks changing the order, however.

rustywave

it really would be a lot easier if you did...maybe try something like what elistan did. or use the [ code ] tags

are lines 2 and 4 blank rows? you could write a script

[CODE]
private sub blah