View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Duddly Dummy[_2_] Duddly Dummy[_2_] is offline
external usenet poster
 
Posts: 1
Default How can I count BOLD letters in a cell?

I need to create 2 cells from one cell based on Bold Type. The Bold type
characters (name) will be copied into one new cell with the rest of the
characters (registration number, color(bay/chestnut) and dates) in a 2nd new
cell. The original cell can contain up to 28 alpha/numeric characters. How
can I count the number of Bold Type characters in a cell? I will be working
with several hundred original mixed cells.

EX:NAME ahr#1234567 1989 (with NAME being bold type.)

Thanks in advance for your help!!