R
Ron.Winkley
Hi to All,
I have formatted cell C5 as follows: ##"F1"
I entered the number 1712 cell C5, which gives the desired result
1712F1
Now I want to CONCATENATE(C5,xx,xx,xx) to give result 1712F1 xx xx xx
but what I get is 1712 xx xx xx
Note that the formatting of cell C5 is variable and will change,
for example from ##"F1" to ##"P1", ##"F2" or to something else.
In each case I want the CONCATENATED string to correspond to
the present format of cell C5, for example 1712F2 xx xx xx
How can I achieve this variable format in my CONCATENATED string
to automatically correspond to the format of cell C5?
Thank you for your assistance,
RonW.
I have formatted cell C5 as follows: ##"F1"
I entered the number 1712 cell C5, which gives the desired result
1712F1
Now I want to CONCATENATE(C5,xx,xx,xx) to give result 1712F1 xx xx xx
but what I get is 1712 xx xx xx
Note that the formatting of cell C5 is variable and will change,
for example from ##"F1" to ##"P1", ##"F2" or to something else.
In each case I want the CONCATENATED string to correspond to
the present format of cell C5, for example 1712F2 xx xx xx
How can I achieve this variable format in my CONCATENATED string
to automatically correspond to the format of cell C5?
Thank you for your assistance,
RonW.