Typo Patrol<g

Try =UPPER(A1)&" "&A2

Kevin

There is no BOLD or FONTCOLOR function.

You can use the Case function as Peo has shown.

To get the Bold part you can copypaste specialvalues then Bold ABCDEF
manually.


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 09:48:02 -0800, "Peo Sjoblom" wrote:

Are you saying that the text changes to lower case when you use the formula?
egardless to have upper case you can use

=UPPER(A1)" "&A2

--

Regards,

Peo Sjoblom


"Kevin McCartney" wrote in
message ...
Hi TWIMC

I need to how to change a proportion of text in a resulting concatenation
formula.

cell A1 contains the text in bold "ABCDEF", cell A2 containes "GHIJKLM"
cell
A3 contains =A1 & " " & A2 but I want the cell A1 part to remain in bold.
Is
there a way of using the TEXT function e.g. =TEXT(A1,BOLD) & " " & A2?

TIA
KM