ExcelBanter - Custom Cell Format

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

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

- - Custom Cell Format (https://www.excelbanter.com/excel-worksheet-functions/21131-custom-cell-format.html)

SimonW

Custom Cell Format

Hi

Is there a way to apply a cell format so that any keyed character returns a —
This is U+25CF in Character Map.

I am counting dots in an Astrogical model.

TIA, Simon

Gary Brown

Not EXACTLY what you want but...
In A1 put your text.
In B1 put this formula...
=REPT(CHAR(149),LEN(A1))
HTH,
Gary Brown

"SimonW" wrote:

Hi

Is there a way to apply a cell format so that any keyed character returns a —
This is U+25CF in Character Map.

I am counting dots in an Astrogical model.

TIA, Simon

All times are GMT +1. The time now is 05:41 PM.