Software

Ask something
Question Locked

Combining colums in Excel

0 helpful
3 replies

by rhemraj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I was hoping someone could help me out: I have two columns... one w the month (numbered 1-12) the other w/ the year (1939-xxxx) I need the columns combined to read (193901, 193902 etc). However whenever i attempt to do this it comes out 19392 in stead of 193902. I than do a copy/paste value in a new column to change the format to read as a date, however, the year gets changed. I know this might have something to do w/ converting it to txt format, however, ijust can't seem to figure it out. Any help/feed back would be appreciated.

Thank you!

3 replies

by bizzo

Delete the columns and insert a blank one
In the first cell type 01/01/1939, in the second, type 01/02/1939. Highlight those two cells and drag/fill up to the date you require. Make sure each row changes the month, and not the day. (you may need to change to 02/01/1939 is you default to US format dates)

Highlight the column, right click, and format cells. Select Custom, and in the "type, type yyyymm, this will convert the dates to the format you require.

The dates will still be stored as dates, just displayed as yyyymm, so be careful, if you do any processing/arithmetic with the "dates".

by raraschek

If you do not need to be the cell "193901" as a number format and text format is OK for you, here is a simple way how to manage that.

1.Select both columns
2.Make them Format>Cells>Type>Text
3.In the next column type
=A1&B1
where A1 is the cell with 1939
and B1 is the cell with 01
and copy paste this as where you need to.

This discussion is closed to new replies.