ExcelBanter - Formatting text output within formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formatting text output within formulas (https://www.excelbanter.com/excel-worksheet-functions/216778-formatting-text-output-within-formulas.html)

Colin Hayes

Formatting text output within formulas

HI All

This is the formula I have :

="Trial : "&(ExpirationDate-TODAY())&" days remaining."

I'm trying to make bold the output from the '&(ExpirationDate-TODAY())&'
section.

I can't find a way. Can anyone advise?

Best Wishes

Pete_UK

Formatting text output within formulas

No, Excel does not allow you to do that within formulae.

Hope this helps.

Pete

On Jan 16, 2:01*pm, Colin Hayes wrote:
HI All

This is the formula I have :

="Trial : "&(ExpirationDate-TODAY())&" days remaining."

I'm trying to make bold the output from the '&(ExpirationDate-TODAY())&'
section.

I can't find a way. Can anyone advise?

Best Wishes

All times are GMT +1. The time now is 02:20 PM.