Multiple fonts in one cell
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 |
Multiple fonts in one cell
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 |
Multiple fonts in one cell
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 |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com