text to be uppersize in the cell

KAR FUNG 101 Reputation points
2026-06-14T04:13:28.4433333+00:00

Hi Sir,

The formula below is to link the tab name to cell.

=MID(@CELL("filename",B1),FIND("]",@CELL("filename",B1))+1,256)

I wish the text to be uppercase in the cell and keep the text in the tab to be lowercase. Kindly advise.

Thanks.

Microsoft 365 and Office | Excel | Other | Other
0 comments
Answer accepted by question author

AI answer

2026-06-14T04:13:41.8466667+00:00

Use the UPPER function around the existing formula so only the displayed text is uppercase while the sheet (tab) name stays lowercase:

=UPPER(MID(@CELL("filename",B1),FIND("]",@CELL("filename",B1))+1,256))

This converts the extracted sheet name to uppercase in the cell without changing the actual tab name.

References:

AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

2 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.