I need to combine month, date and year into a single column into 1/1/1998, 1/2/1998 as in mm/dd/yyyy. I need this format for a software input. Please find attached the spreadsheet im using. Appreciate any help.
Thanks
I need to combine month, date and year into a single column into 1/1/1998, 1/2/1998 as in mm/dd/yyyy. I need this format for a software input. Please find attached the spreadsheet im using. Appreciate any help.
Thanks
CONCATENATE
Joins two or more text strings into one text string.
Syntax
CONCATENATE (text1,text2,...)
Text1, text2, ... are 2 to 255 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Remarks
You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1&B1 returns the same value as =CONCATENATE(A1,B1).
Ben Van Johnson
Try this.
=DATE(C2,A2,B2)
and use custom formatting mm/dd/yyy
Last edited by vogel997; 08-04-2014 at 10:25 PM.
Many thanks for the quick reply.
Follwing the first suggestion by Proton Leah, I manged to combine them but I need the column to be in mm/dd/yyy format and I could not change it. Do you have a suggestion?
The second suggestion by Vogel 997 showed the following. The month and date is correct but the year is wrong. can you suggest something?
1 1 1889.00 01-01-3789
1 2 1889 01-02-3789
1 3 1889 01-03-3789
1 4 1889 01-04-3789
1 5 1889 01-05-3789
1 6 1889 01-06-3789
1 7 1889 01-07-3789
Regards
=b2&"/"&a2&"/"&c2
Or if you prefer:
=TEXT(A2,"00")&"/"&TEXT(B2,"00")&"/"&C2
=TEXT(B2&"/"&A2&"/"&C2,"mm/dd/yyyy")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks