ExcelBanter - Formatting within Formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting within Formula (https://www.excelbanter.com/excel-discussion-misc-queries/205523-formatting-within-formula.html)

Russell

Formatting within Formula

Is it possible to apply formating to text within a formula. For example I
would like the "st" to be superscript.

=INT((MONTH(A2)+2)/3)&"st Quarter "&RIGHT(YEAR(A2),4)

Thanks in advance

John C[_2_]

Formatting within Formula

--
John C

"Russell" wrote:

Is it possible to apply formating to text within a formula. For example I
would like the "st" to be superscript.

=INT((MONTH(A2)+2)/3)&"st Quarter "&RIGHT(YEAR(A2),4)

Thanks in advance

John C[_2_]

Formatting within Formula

Sorry, blank post. In a nutshell, no, it is not possible within a formula to
do as you are wanting.
--
John C

"John C" wrote:

--
John C

"Russell" wrote:

Is it possible to apply formating to text within a formula. For example I
would like the "st" to be superscript.

=INT((MONTH(A2)+2)/3)&"st Quarter "&RIGHT(YEAR(A2),4)

Thanks in advance

All times are GMT +1. The time now is 08:56 AM.