software

Hi TWIMC

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

cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes quot;GHIJKLMquot; cell
A3 contains =A1 amp; quot; quot; amp; 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) amp; quot; quot; amp; A2?

TIA
KM

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)quot; quot;amp;A2

--

Regards,

Peo Sjoblomquot;Kevin McCartneyquot; gt; wrote in
message ...
gt; Hi TWIMC
gt;
gt; I need to how to change a proportion of text in a resulting concatenation
gt; formula.
gt;
gt; cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes quot;GHIJKLMquot;
cell
gt; A3 contains =A1 amp; quot; quot; amp; A2 but I want the cell A1 part to remain in bold.
Is
gt; there a way of using the TEXT function e.g. =TEXT(A1,BOLD) amp; quot; quot; amp; A2?
gt;
gt; TIA
gt; KM
NO, I'm saying that the first part is in bold, BOLD means, well bold text,
like Italic or Underlined ..... definitely not UPPER case that you thought.

Anyone else have any ideas or do I have to re post?

regards
KMquot;Peo Sjoblomquot; wrote:

gt; Are you saying that the text changes to lower case when you use the formula?
gt; egardless to have upper case you can use
gt;
gt; =UPPER(A1)quot; quot;amp;A2
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt; quot;Kevin McCartneyquot; gt; wrote in
gt; message ...
gt; gt; Hi TWIMC
gt; gt;
gt; gt; I need to how to change a proportion of text in a resulting concatenation
gt; gt; formula.
gt; gt;
gt; gt; cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes quot;GHIJKLMquot;
gt; cell
gt; gt; A3 contains =A1 amp; quot; quot; amp; A2 but I want the cell A1 part to remain in bold.
gt; Is
gt; gt; there a way of using the TEXT function e.g. =TEXT(A1,BOLD) amp; quot; quot; amp; A2?
gt; gt;
gt; gt; TIA
gt; gt; KM
gt;
gt;
gt;

Doh! Sorry about that, no there is no built in function that will do that--

Regards,

Peo Sjoblom

quot;Kevin McCartneyquot; gt; wrote in
message ...
gt; NO, I'm saying that the first part is in bold, BOLD means, well bold text,
gt; like Italic or Underlined ..... definitely not UPPER case that you
thought.
gt;
gt; Anyone else have any ideas or do I have to re post?
gt;
gt; regards
gt; KM
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Are you saying that the text changes to lower case when you use the
formula?
gt; gt; egardless to have upper case you can use
gt; gt;
gt; gt; =UPPER(A1)quot; quot;amp;A2
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt;
gt; gt; quot;Kevin McCartneyquot; gt; wrote in
gt; gt; message ...
gt; gt; gt; Hi TWIMC
gt; gt; gt;
gt; gt; gt; I need to how to change a proportion of text in a resulting
concatenation
gt; gt; gt; formula.
gt; gt; gt;
gt; gt; gt; cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes
quot;GHIJKLMquot;
gt; gt; cell
gt; gt; gt; A3 contains =A1 amp; quot; quot; amp; A2 but I want the cell A1 part to remain in
bold.
gt; gt; Is
gt; gt; gt; there a way of using the TEXT function e.g. =TEXT(A1,BOLD) amp; quot; quot; amp; A2?
gt; gt; gt;
gt; gt; gt; TIA
gt; gt; gt; KM
gt; gt;
gt; gt;
gt; gt;
So how come if you type an load of text into a cell, select half of it, click
on the Bold button on the menu bar, press enter and half of the cell contents
are in bold but the othe half are not. How does Excel do it?

Any ideas, much appriciated.

ciao
KM

quot;Peo Sjoblomquot; wrote:

gt; Doh! Sorry about that, no there is no built in function that will do that
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;Kevin McCartneyquot; gt; wrote in
gt; message ...
gt; gt; NO, I'm saying that the first part is in bold, BOLD means, well bold text,
gt; gt; like Italic or Underlined ..... definitely not UPPER case that you
gt; thought.
gt; gt;
gt; gt; Anyone else have any ideas or do I have to re post?
gt; gt;
gt; gt; regards
gt; gt; KM
gt; gt;
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt; gt; Are you saying that the text changes to lower case when you use the
gt; formula?
gt; gt; gt; egardless to have upper case you can use
gt; gt; gt;
gt; gt; gt; =UPPER(A1)quot; quot;amp;A2
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Peo Sjoblom
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Kevin McCartneyquot; gt; wrote in
gt; gt; gt; message ...
gt; gt; gt; gt; Hi TWIMC
gt; gt; gt; gt;
gt; gt; gt; gt; I need to how to change a proportion of text in a resulting
gt; concatenation
gt; gt; gt; gt; formula.
gt; gt; gt; gt;
gt; gt; gt; gt; cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes
gt; quot;GHIJKLMquot;
gt; gt; gt; cell
gt; gt; gt; gt; A3 contains =A1 amp; quot; quot; amp; A2 but I want the cell A1 part to remain in
gt; bold.
gt; gt; gt; Is
gt; gt; gt; gt; there a way of using the TEXT function e.g. =TEXT(A1,BOLD) amp; quot; quot; amp; A2?
gt; gt; gt; gt;
gt; gt; gt; gt; TIA
gt; gt; gt; gt; KM
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

But it won't work with a formula even if you do it manually.

Kevin McCartney wrote:
gt;
gt; So how come if you type an load of text into a cell, select half of it, click
gt; on the Bold button on the menu bar, press enter and half of the cell contents
gt; are in bold but the othe half are not. How does Excel do it?
gt;
gt; Any ideas, much appriciated.
gt;
gt; ciao
gt; KM
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Doh! Sorry about that, no there is no built in function that will do that
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; quot;Kevin McCartneyquot; gt; wrote in
gt; gt; message ...
gt; gt; gt; NO, I'm saying that the first part is in bold, BOLD means, well bold text,
gt; gt; gt; like Italic or Underlined ..... definitely not UPPER case that you
gt; gt; thought.
gt; gt; gt;
gt; gt; gt; Anyone else have any ideas or do I have to re post?
gt; gt; gt;
gt; gt; gt; regards
gt; gt; gt; KM
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Are you saying that the text changes to lower case when you use the
gt; gt; formula?
gt; gt; gt; gt; egardless to have upper case you can use
gt; gt; gt; gt;
gt; gt; gt; gt; =UPPER(A1)quot; quot;amp;A2
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Regards,
gt; gt; gt; gt;
gt; gt; gt; gt; Peo Sjoblom
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Kevin McCartneyquot; gt; wrote in
gt; gt; gt; gt; message ...
gt; gt; gt; gt; gt; Hi TWIMC
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I need to how to change a proportion of text in a resulting
gt; gt; concatenation
gt; gt; gt; gt; gt; formula.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes
gt; gt; quot;GHIJKLMquot;
gt; gt; gt; gt; cell
gt; gt; gt; gt; gt; A3 contains =A1 amp; quot; quot; amp; A2 but I want the cell A1 part to remain in
gt; gt; bold.
gt; gt; gt; gt; Is
gt; gt; gt; gt; gt; there a way of using the TEXT function e.g. =TEXT(A1,BOLD) amp; quot; quot; amp; A2?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; TIA
gt; gt; gt; gt; gt; KM
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

Typo Patrollt;ggt;

Try =UPPER(A1)amp;quot; quot;amp;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 copygt;paste specialgt;values then Bold ABCDEF
manually.Gord Dibben Excel MVP

On Fri, 16 Dec 2005 09:48:02 -0800, quot;Peo Sjoblomquot; gt; wrote:

gt;Are you saying that the text changes to lower case when you use the formula?
gt;egardless to have upper case you can use
gt;
gt;=UPPER(A1)quot; quot;amp;A2
gt;
gt;--
gt;
gt;Regards,
gt;
gt;Peo Sjoblom
gt;
gt;
gt;quot;Kevin McCartneyquot; gt; wrote in
gt;message ...
gt;gt; Hi TWIMC
gt;gt;
gt;gt; I need to how to change a proportion of text in a resulting concatenation
gt;gt; formula.
gt;gt;
gt;gt; cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes quot;GHIJKLMquot;
gt;cell
gt;gt; A3 contains =A1 amp; quot; quot; amp; A2 but I want the cell A1 part to remain in bold.
gt;Is
gt;gt; there a way of using the TEXT function e.g. =TEXT(A1,BOLD) amp; quot; quot; amp; A2?
gt;gt;
gt;gt; TIA
gt;gt; KM

Kevin McCartney wrote:
gt; Hi TWIMC
gt;
gt; I need to how to change a proportion of text in a resulting concatenation
gt; formula.
gt;
gt; cell A1 contains the text in bold quot;ABCDEFquot;, cell A2 containes quot;GHIJKLMquot; cell
gt; A3 contains =A1 amp; quot; quot; amp; A2 but I want the cell A1 part to remain in bold. Is
gt; there a way of using the TEXT function e.g. =TEXT(A1,BOLD) amp; quot; quot; amp; A2?
gt;
gt; TIA
gt; KM
You can do this with a VBA sub, but it will require having the sub
remove the formula and replace it with just the text string. There are
ways to make this volatile, also. But you would have to provide more
precise specifications.

If interested, post back amp; I'll post some code when I get back home
tomorrow or Monday.

~ron

quot;Kevin McCartneyquot; gt; wrote...
gt;So how come if you type an load of text into a cell, select half of it,
gt;click
gt;on the Bold button on the menu bar, press enter and half of the cell
gt;contents
gt;are in bold but the othe half are not. How does Excel do it?
....

No one is saying there's a good reason you can't do this in formulas, though
it'd require running the formatting engine after the recalculation engine if
it were possible.

In a nut shell, Excel provides access to the rich text Characters object for
cells containing literals, but it doesn't provide access to this class for
cells containing formulas. It's a design decision/limitation. Nothing can be
done to change it until Microsoft decides to reprogram it.
It is funny though, because in the mid 90's Lotus-123 was able to have
different formats in formulas (e.g. Bold, Italic, underline and font colors
etc.). Strange that Microsoft have chosen that limitation.quot;Harlan Grovequot; skrev:

gt; quot;Kevin McCartneyquot; gt; wrote...
gt; gt;So how come if you type an load of text into a cell, select half of it,
gt; gt;click
gt; gt;on the Bold button on the menu bar, press enter and half of the cell
gt; gt;contents
gt; gt;are in bold but the othe half are not. How does Excel do it?
gt; ....
gt;
gt; No one is saying there's a good reason you can't do this in formulas, though
gt; it'd require running the formatting engine after the recalculation engine if
gt; it were possible.
gt;
gt; In a nut shell, Excel provides access to the rich text Characters object for
gt; cells containing literals, but it doesn't provide access to this class for
gt; cells containing formulas. It's a design decision/limitation. Nothing can be
gt; done to change it until Microsoft decides to reprogram it.
gt;
gt;
gt;