Combine information?

[Percocet7]

Hello,

How can i combine cells and have them show in one cell in a certain order in one cell?

Thanks in advance for your help!

[twiggywales]

just use the & symbol

eg

A2&A3&B5

[arlu1201]

You can use concatenate or just the "&" sign after each cell to be combined. Do you have any specific examples you need help with?

[tom1977]

Hi
using this symbol "&" I think You will get what You need

[Percocet7]

Where do i put the and symbol? I am basically trying to get colum A to combine with b and c but i want the data to show in a certain order ie. A then B then C.

[arlu1201]

In D2, put =A2&B2&C2

[galvinpaddy]

In cell D1 type -

Please Login or Register  to view this content.

then hit enter, if your info stretches more than just row 1, copy the formula downwards.
Please note, doing the above will join all the info in the cell, with no spaces or separators, if you need to separate the info you will need to type

Please Login or Register  to view this content.

this will put a space between the info, you can use anything you like to separate the data.

" " space
"*" Star
"." Full Stop
"," Comma

galvinpaddy

[Percocet7]

Sorry to be so stupid about this but how do i get it to do it for the whole spreadsheet? I really appreciate your help btw.

[twiggywales]

you set up one cell then click the bottom right hand side of the cell and drag as required

[galvinpaddy]

@ arlu1201 - Apologies and thanks.

@ Percocet7 - see image attached. put your mouse icon over the bottom right corner of the cell, wait for it to change into a black plus sign, then double click (or you can click, hold, and drag downwards

[galvinpaddy]

Also, no need for apologies, we all have to start somewhere with Excel! the best way to learn is probably through the experience of others.

[Percocet7]

I tried your suggestion gavinpaddy and it did not work, it just copied the code down the cells.

[twiggywales]

do you have a spreadsheet you could upload?

[galvinpaddy]

Hi

This will only collate the info from Cells A1, B1 & C1.
If you information is not in these cells, then change it to the correct cell reference, just another thought, the cells where you have typed the formula, are they formatted as general or text??
probably best to load a sheet as twiggywales suggested!

[Percocet7]

I have uploaded the file, I am trying to combine C with D, E etc with spaces in between, then the next part will be to figure out how to add text to every cell before the text thats already in there or after it. I had a macro but i forgot how to do it =(

[galvinpaddy]

thanks for that, next question, the data that is combined, where do you want this?

[galvinpaddy]

ok, first attempt, i have inserted a new column between Type & rarity, this collates the info, the the column Type2 has been hidden from view.
Is that what you wanted for one part of your request?

[Percocet7]

In any cell. The real file is a few MB so i really just need to know how to get it done so i can do it to the real worksheet and fool around with it so i can add text to it then combine.

[Percocet7]

What are you doing to get them two together? It just combines them then you delete the old cells?

[galvinpaddy]

Very simply put, if you have a worksheet, and in A1, B1 & C1 you have text, and in D1 you want to combine all text from A1, B1 & C1, separated by a space, you must type into cell D1 -

Please Login or Register  to view this content.

this will combine the info from all 3 with a space between them.

Hope that helps