View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dunc Dunc is offline
external usenet poster
 
Posts: 5
Default Counting characters in text cell to find 255 limit

I have an Excel data base that I want to use to create a Publisher
document.... kind of like a catalog

Publisher will only allow the import of 255 characters into a merge field.
This means that I will have to break up text in my Excel database into
chunks of 255 and create multiple merge fields in Publisher (Like
Comments1, Comments2 etc.)

What I am looking for is a way to have my mouse highlight and count the
number of characters as it is highlighting the text.

Is there a way to accomplish this??

Thanks!

Dunc