How to Bold partial a text in Excel

[nikos]

Hi to everyone.
I want to bold certain areas of a text (only part of the text). For example
lets say I have the phrase “Mr John Smith is a software engineer and is 42
years oldâ€, where the name and age are taken from cells in the sheet – these
I want to appear as bold- and I also need the “software engineer†to appear
as bold, though it is not drawn from any cell.
Is that possible without programming?

Thank you.

 

[Roger Govier]

Hi Nikos

without using VBA, I don't think this is possible.

 

[moily]

Hi Nikos,

It looks like you can't bold certain sections of a formula because
"formatting is applied to a specific character location, and such locations
vary depending on the result of the formula. There is no way for Excel to
know in advance how to format a result it doesn't know yet." Apparently vba
code can be written that replaces the formula. I think these websites might
help:

http://www.mrexcel.com/forum/showthread.php?t=6797
http://www.microsoft.com/communitie...22-a77d-aa433ce95e6d&cat=&lang=&cr=&sloc=&p=1
http://www.developersdex.com/vb/message.asp?p=2677&r=6331057

 

[Ron Rosenfeld]

Hi to everyone.
I want to bold certain areas of a text (only part of the text). For example
lets say I have the phrase “Mr John Smith is a software engineer and is 42
years old”, where the name and age are taken from cells in the sheet – these
I want to appear as bold- and I also need the “software engineer” to appear
as bold, though it is not drawn from any cell.
Is that possible without programming?

Thank you.

Without programming, YES but it is cumbersome.

In Excel, you can only "differentially format" a portion of a text string.

So your cell contents must first be converted into a text string -- e.g.
select the cell
F2
F9
Enter

Then select the words you wish to bold (e.g. in the formula bar)
<ctrl-b>

--ron

 

[moily]

Wouldn't it be easier just to highlight all the cells, copy and paste special
values the entire lot all at once rather than doing them one by one? You'd
still have to bold the particular parts of the sentence though manually.

 

[Ron Rosenfeld]

Wouldn't it be easier just to highlight all the cells, copy and paste special
values the entire lot all at once rather than doing them one by one? You'd
still have to bold the particular parts of the sentence though manually.

The OP only mentioned a single cell so it doesn't really make much difference.
--ron

 

[Lori Miller]

Maybe you could do this by copying and pasting. eg copy:

<table><td>Mr <b>John Smith</b> is a <b>Software Engineer</b> and is
<b>42</b> years old

and paste special as text. You could create text formulas like:
="<table><td>Mr <b>"&A1&... fill down and copy and paste the list to and from
notepad.

 

[nikos]

Thank you all.

Maybe you could do this by copying and pasting. eg copy:

<table><td>Mr <b>John Smith</b> is a <b>Software Engineer</b> and is
<b>42</b> years old

and paste special as text. You could create text formulas like:
="<table><td>Mr <b>"&A1&... fill down and copy and paste the list to and from
notepad.