Community archive

Ask something
Discussion Locked

Combining Excel columns

0 helpful
3 replies

by barry b.

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have received several requests to combine columns, e.g., three parts of a soc sec no. into one or separate mm, dd, and yyyy into one mmddyyyy. We have not yet found a way to do this.

3 replies

by txbluebonnet

If a merging of cells the reformating of the cells to the new requirement doesn't work, then you may not like the response......

manual labor!!!

Insert a new column, format it properly and type in the correct data; when complete delete the other 3 columns!!!

by barry b.

I found an answer! Insert a new column, type =concatenate(c1,c2,c3), and copy the formula into all rows of the new column. Then hide or delete the original three.

This discussion is closed to new replies.