microsoft excel
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. |
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)
|
i dont understand, how is control c gonna combine the contacts together i tried and it just has a moving box.
|
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. :shrug: I guess I don't understand what you want, sorry :sadwave: |
This sort of thing, perhaps:
Col A --- Col B --- Col C --- Col D Name --- junk --- phone --- =A1&" "&C1 The "&" function concatenates strings. |
[QUOTE=Elistan,Sep 4 2010, 04:05 PM]This sort of thing, perhaps:
Col A |
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.
|
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? |
Originally Posted by emrillive,Sep 5 2010, 10:47 AM
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? |
Originally Posted by emrillive,Sep 6 2010, 02:47 AM
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? are lines 2 and 4 blank rows? you could write a script [CODE] private sub blah |
All times are GMT -8. The time now is 03:30 AM. |
© 2024 MH Sub I, LLC dba Internet Brands