Help Quick ~ Any MS Excel Experts out there?

[DwarfMaster]

I need to know if there's anyway to merge the information from 3 seperate cells all into 1 cell.

Ex: AAAA BBBB CCCC
To: AAAABBBBCCCC

I can't figure it out .... it looks like I may have to do the old copy & paste

 

[TerriP]

Highlight the cells. Go to "Format", then click on "Cells", then click on the "Alignment" tab...middle section, last option, check the box that says "Merge Cells".

 

[cardaway]

Concatenate(aaaa,bbbb,cccc)

 

[Bob Slydell]

Concatenate(aaaa,bbbb,cccc)

Or =(A1)&(B1)&(C1) (assuming they're in cells A1, B1, and C1.

 

[DwarfMaster]

I'm not sure what concatenate even means?

I think the problem may be that these are numbers....I don't want to add them together just combine them into one cell.

Like a phone number that was split up into 3 cells. 111 555 1212 I need 1115551212 all in one cell.

 

[Bob Slydell]

I'm not sure what concatenate even means?

I think the problem may be that these are numbers....I don't want to add them together just combine them into one cell.

Like a phone number that was split up into 3 cells. 111 555 1212 I need 1115551212 all in one cell.

Concatenate means combine. It's an Excel formula used to merge cells. Like I posted above, you'd get the same results using & in between your cells as well.

 

[DwarfMaster]

It worked!!!!

You guys must have saved me HOURS of retyping! There were thousands of #s here!



THANK YOU!!!!