Can anyone help me.
I am using Excel 2000 on Windows XP pro. I have used the following worksheet formula:
=CONCATENATE("Employees Name: ",L3," Week Start: ",TEXT(L4-DAY(6), "dd-mm-yyyy")," Week End: ",TEXT(L4, "dd-mm-yyyy"))
The trick now is that I want the text returned from the cells to be formatted differently (differnet color plus underlined) to the text returned from the formula ("Employees Name:" etc, etc)
Is there any way of doing this as I'm scratching my head.
Thanks in advance
Marty.E
I am using Excel 2000 on Windows XP pro. I have used the following worksheet formula:
=CONCATENATE("Employees Name: ",L3," Week Start: ",TEXT(L4-DAY(6), "dd-mm-yyyy")," Week End: ",TEXT(L4, "dd-mm-yyyy"))
The trick now is that I want the text returned from the cells to be formatted differently (differnet color plus underlined) to the text returned from the formula ("Employees Name:" etc, etc)
Is there any way of doing this as I'm scratching my head.
Thanks in advance
Marty.E