You don't have the 11th character visible in the column?

You are zoomed out and can't distinguish between bold and normal?


worked fine for me in xl97 and xl2003.

--
Regards,
Tom Ogilvy


"Jim May" wrote:

Tom,
After running macro I don't see a visual change in the cells selected. If
on any given cell I press F2 (edit mode) then
only do I see the 11th character in bold, but after leaving edit mode it
doesn't show the change (that is reflected in the edit mode).
hummm,,
any suggestions?
Jim May

"Tom Ogilvy" wrote in message
...
Sub Bold11thCharacter()
Dim cell As Range
For Each cell In Selection
If Len(cell) 10 Then
cell.Characters(11, 1).Font.Bold = True
End If
Next

End Sub

select the cells in the column and run the macro.

Assumes the characters are constants and not produced with a formula

--
Regards,
Tom Ogilvy



"Excel_Newbie09"
wrote in
message news:Excel_Newbie09.25nzfa_1144027200.847@excelfor um-nospam.com...

Hey guys. I am new here and new to excel so go easy on me :)

I have a colum with 21 random characters in each cell. Is it possible
to find the 11th character in each cell within only that colum and to
make that character bold or red or something else so as to make it
stand out. Not sure if this could be done in excel so I thought I might
seek some expert help :D

Cheers


--
Excel_Newbie09
------------------------------------------------------------------------
Excel_Newbie09's Profile:
http://www.excelforum.com/member.php...o&userid=33094
View this thread:
http://www.excelforum.com/showthread...hreadid=529050