I have a spreadsheet that a cell displays part of the worksheet name
(tab).
We use a formula to keep it up to date:

="Sheet "&
MID(CELL("filename",B11),FIND("]",CELL("filename",B11))+2,
LEN(CELL("filename",B11))-FIND("]",CELL("filename",B11)))

The word ”Sheet” and a few spaces is always infront of the imported
worksheet name. For format consistence sake, I need the word “Sheet”
to always be bold font and the work sheet name to be normal or “not
bold”

Can I do this in the formula or with a macro or ???

Thanks
Robert Hatcher


--
Hammer_757
------------------------------------------------------------------------
Hammer_757's Profile: http://www.excelforum.com/member.php...fo&userid=7413
View this thread: http://www.excelforum.com/showthread...hreadid=399469

It is not possible for a formula to display a result with more than one
font. The cell has to have a constant in it to do that.

--
Jim
"Hammer_757" wrote
in message ...

I have a spreadsheet that a cell displays part of the worksheet name
(tab).
We use a formula to keep it up to date:

="Sheet "&
MID(CELL("filename",B11),FIND("]",CELL("filename",B11))+2,
LEN(CELL("filename",B11))-FIND("]",CELL("filename",B11)))

The word ”Sheet” and a few spaces is always infront of the imported
worksheet name. For format consistence sake, I need the word “Sheet”
to always be bold font and the work sheet name to be normal or “not
bold”

Can I do this in the formula or with a macro or ???

Thanks
Robert Hatcher


--
Hammer_757
------------------------------------------------------------------------
Hammer_757's Profile:
http://www.excelforum.com/member.php...fo&userid=7413
View this thread: http://www.excelforum.com/showthread...hreadid=399469

thats dissapointing :( but thanks for the help :)


--
Hammer_757
------------------------------------------------------------------------
Hammer_757's Profile: http://www.excelforum.com/member.php...fo&userid=7413
View this thread: http://www.excelforum.com/showthread...hreadid=399469