hi
another way...
=86&char(186)
leave as is or copy and paste as values.

regards
FSt1

"Niek Otten" wrote:

Press and hold the ALT key, on the numeric keypad, type 0186, release the ALT key
It may depend on which font you use. It certainly works for popular fonts like Arial and Times New Roman

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Trixie" wrote in message ...
|