hey 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.

 

Concatenate. It's a function that combine data from different cells into a single column.

 

8 rows of blanks between contacts? What's that about?

 

im sorry but how would i use it?
and yea inbetween are just abunch of other info like twitter address,facebook address,etc.. other info that is just garbage to me. so it makes it very annoying to me having to scroll up like 1 page just to put together 2 contacts together.

 

Re-reading your first post, not sure Concatenate alone is enough. Can you post screen shot of what you data looks like before doing anything to it?


How to use concatenate: Click the little fx (funciton) button. From the all functions dropdown choose Concatenate. Follow the instructions (text1, text2, etc).

 

Just hide rows or columns.

 

That. And also describe how you want it to look afterwards.

 

you can use & too. like =a&b will combine the data in those cellls.