The goal of this is to be able to format only part of the text in a cell.

I am trying to create a line of text which changes formatting depending on a
number of variables. What I am after is a system which will turn a line of
text (e.g. llllllllllllll and be able to manupilate part of it by way of a
coded formula. (So if a value is entered the text gets formatted accordingly.
so if a value is entered for '4' in one cell the text is formatted to
something like LLLL(!in red)then continues as llllllllll.

Alternateively, I would accept an easy way of converting text into different
formats within the cell so I could say "If I enter in the number '4' then
make the first 4 letters in the text BOLD.

Can this be done?

This can't be done with formulas. You may try venturing over to the
excel.programming forum.
--
JNW


"TroyG" wrote:

The goal of this is to be able to format only part of the text in a cell.

I am trying to create a line of text which changes formatting depending on a
number of variables. What I am after is a system which will turn a line of
text (e.g. llllllllllllll and be able to manupilate part of it by way of a
coded formula. (So if a value is entered the text gets formatted accordingly.
so if a value is entered for '4' in one cell the text is formatted to
something like LLLL(!in red)then continues as llllllllll.

Alternateively, I would accept an easy way of converting text into different
formats within the cell so I could say "If I enter in the number '4' then
make the first 4 letters in the text BOLD.

Can this be done?

Can this be done?

Not with a formula. You can get a formula to do this part:

if a value is entered for '4' in one cell the text is LLLL then continues
as llllllllll.

But to get this:

LLLL(!in red)then continues as llllllllll.

You'll need some VBA code. Stick around, someone will chime in with a
solution.

Biff

"TroyG" wrote in message
...
The goal of this is to be able to format only part of the text in a cell.

I am trying to create a line of text which changes formatting depending on
a
number of variables. What I am after is a system which will turn a line of
text (e.g. llllllllllllll and be able to manupilate part of it by way of a
coded formula. (So if a value is entered the text gets formatted
accordingly.
so if a value is entered for '4' in one cell the text is formatted to
something like LLLL(!in red)then continues as llllllllll.

Alternateively, I would accept an easy way of converting text into
different
formats within the cell so I could say "If I enter in the number '4' then
make the first 4 letters in the text BOLD.

Can this be done?