View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Yawrood
 
Posts: n/a
Default format part of text in a cell?

Hi Bryan and thanks - I'm using Excel 2003 - Office Professional Suite. I
have 3 words of text - William Smith, Payroll. I was trying to bold
"Payroll" as well as enlarge it from 6 to 9 points.

However, reading your response wherein you say "......(not in Text
format)....." caused me to double check the formatting for the entire column.
I don't recall ever having changed that column from "Text" to "Accounting"
but sure enough, when I checked, it was "Accounting". No wonder it wouldn't
work. But I've corrected my mistake and now can format it as desired.

Thanks to all.



"Bryan Hessey" wrote:


As Biff said, if your cell contains text (ie "this edited word" ) and
you highlight the 'Edited' and set it's attributes then the text should
remain formatted.

If you mean that the cell contains (say) 257 (not in Text format) and
you are trying to highlight the '5' then you will have problems as you
describe.

Can you explain what you are trying to highlight, and what version of
Excel you are using?

--

Yawrood Wrote:
Biff - I did that. As soon as i move the cursor to another cell, the
formatting goes away.

"Biff" wrote:

Hi!

Select the cell in question.

In the formula bar, highlight the text you want to format.

Then goto FormatCells

Biff

"Yawrood" wrote in message
...
Excel cell contains 3 words of text. I want to make one of the

words
smaller
and bolded. As soon as I perform edit, edit goes away as soon as I

move
cursor off cell.

Why? How can I edit part of the text so that it stays edited?





--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=547645