How to copy formatting in a Concatenate formula

[Nicole]

I have a Concatenate formula (Excel 97) that takes dates,
text and numbers from various cells. The cell it is taking
the data from is formatted and this formatting should also
show in the resulting cell. Does anyone know what to do in
order to achieve this?

Kind regards

Nicole

 

[Paul]

I have a Concatenate formula (Excel 97) that takes dates,
text and numbers from various cells. The cell it is taking
the data from is formatted and this formatting should also
show in the resulting cell. Does anyone know what to do in
order to achieve this?

Kind regards

Nicole

You can't do this as such. If formatting is to apply to only part of the
contents of a cell, you must do it manually (or with a macro, which would
likely be quite involved). You can (of course) format the whole cell
manually or using conditional formatting, which may allow you to do part of
what you want.

 

[Bob Phillips]

Nicole,

Try something like

=TEXT(A1,"#,##0.00") & " items found for " & TEXT(B1,"dd mmm yyyy")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks...I thought about conditional formatting but this
all is not working for this complex spreadsheet. It does
make sense thought that if you have in one cell a text and
you highlight one word, let's say in bold and red, that
you would want this to show in your resulting cell. Never
mind...have to live without it

 

[Guest]

Thanks Bob, I probably wasn't clear with my posting. We
already have the formula as you suggest, however, the
problem is another. See my post reply to Paul's posting.