EXCEL - Join date and text

Closed
Dev - Apr 20, 2012 at 12:21 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2012 at 07:08 AM
Hello,



Below formula is returning date with numbers. can you please give me a solution where I can get date and text.

=IF(F2="FIBSMSAPTREM",TODAY()&B2,"") -------- 41019MR A A (B1 being MR A A)

I want 20/04/2012 Mr A A

1 reply

Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 7
Apr 20, 2012 at 12:58 PM
=IF(F2="FIBSMSAPTREM",DAY(TODAY())&"/"&MONTH(TODAY())&"/"&YEAR(TODAY())&" "&B2,"")
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Apr 21, 2012 at 07:08 AM
Better would be
=IF(F2="FIBSMSAPTREM", TEXT(TODAY(), "dd/mm/yyyy") &" "&B2,"")
0