Combine text and date

[Muthukrishnan V]

Book6.xlsx
	A	B	C	D	E	F
1
2
3		Excel 365
4		Combine Text and date
5					DD-MM-YYYY
6		Balance Sheet			30-09-2023
7		Formula required for Cell B13 to display output,
8	combining B6 and E6
9
10		Balance Sheet45199
11
12		Kindly suggest formula in B13 to output
13		Balance Sheet as on 30-09-2023
14
15		Thanking you,
Sheet1

Cell Formulas
Range	Formula
B10	B10	=B6 &(E6)

 

[Joe4]

Try:

=B6 & TEXT(E6,"dd-mm-yyyy")

 

[Muthukrishnan V]

Thank you Mr Joe sir, a little more help sir,
I want to include "as on" text in between Balance Sheet (B6) and 30-09-2023(E6) sir
Please help.

 

[Joe4]

Thank you Mr Joe sir, a little more help sir,
I want to include "as on" text in between Balance Sheet (B6) and 30-09-2023(E6) sir
Please help.

You can either add it to the end of the text you already have in cell B6, or simply just hard-code it into the formula, i.e.

=B6 & " as on" & TEXT(E6,"dd-mm-yyyy")

 

[Muthukrishnan V]

Thank you Mr Joe sir for your kind help. My problem is solved.
I am grateful to our Forum for the excellent services.

 

[Joe4]

You are welcome.