Help with Microsoft Excel 2000

[paw]

Hello,

Is there a function that combines data from several columns into one column without having to use a formula. I would greatly appreciate any ideas.

Thanks

paw

 

[meintsi]

Try:
CONCATENATE(text1,text2,...)

Should get you what your after. *Remember.......
If you don't use your head,
your going to have to use your feet.

 

[paw]

Thanks - I will give it a try.

paw

 

[paw]

It's me again. Isn't concatenate a formula? I need to delete the 3 columns that I am combining after I combine them. Won't that mess up things when you take away the column that the formula refers to?

paw

 

[Dreamboat]

1. Concatenate is a formula. However, you can just as easily put =A1&B1 or =A1&" "&B1 without having to remember how to spell concatenate.

2. Yes. After doing the concatenate, you need to:

--select all the new cells that contain the concatenated text. Hit Copy. Don't move! Hit Edit-Paste special, choose Values, Ok.

--delete the columns that contained the original data.

If you need it to be automated 'cause you're doing it constantly, then you should ask for a VBA solution. Anne Troy
Dreamboat@TheWordExpert.com
Anne@MrExcel.com

 

[paw]

Thank you so much. Everything worked great!

paw