How to Bold partial a text in Excel


N

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.
 
Ad

Advertisements

M

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
 
R

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
 
M

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.
 
R

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
 
Ad

Advertisements

L

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.
 
Ad

Advertisements

N

nikos

Thank you all.

Lori Miller said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top