Hello,
I am trying to create a spreadsheet that contains some formatted
information in cells (for example special time format HHMM and so on). I
would like to create a concatenated string from the formatted values of
the cells and some static texts.
Example
A B C
1 0920 My Event = CONCATENATE("At "; A1; " "; B1)
The result on C1 is like "At 373918,2331441 My Event" even I would like
it to be "At 0920 My Event".
How this should be done?
Thanks,
Ville
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
