Custom Cell Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Not EXACTLY what you want but...
In A1 put your text.
In B1 put this formula...
=REPT(CHAR(149),LEN(A1))
HTH,
Gary Brown
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Text in cells that already have text entered 5
VLOOKUP, a table with text and numerics 7
conditional format rage based on entries within range 7
Need some help with a COUNTIF function 4
Highlight Cell that contains invalid email format 3
Cells only display a maximum number of text characters 4
Conditional formatting based on character count 1
how do i use symbol of degree in excell work sheet using key board 2

Back
Top