How to assign a format for value?
 

Does anyone have any suggestions on how to assign a format for specific value?
for example
There is a date in cell A1 and there is a value in cell B1,
I would like to display A1 & B1 into cell C1, for example
15-Jun [Cell A1] 4 [Cell B1]
15-Jun [4] in Cell C1

Does anyone have any suggestions?
Thank in advance for any suggestions
Eric

How to assign a format for value?
 

One way:

C1: =IF(COUNTA(A1:B1)=2,TEXT(A1,"dd-mmm")&TEXT(B1," \[0\]"),"")

In article ,
Eric wrote:

Does anyone have any suggestions on how to assign a format for specific value?
for example
There is a date in cell A1 and there is a value in cell B1,
I would like to display A1 & B1 into cell C1, for example
15-Jun [Cell A1] 4 [Cell B1]
15-Jun [4] in Cell C1

Does anyone have any suggestions?
Thank in advance for any suggestions
Eric