View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How to count number of characters in xl cell for publisher merge

Use the LEN (Length) function:

=LEN(A1)


--
Biff
Microsoft Excel MVP


"msloell" wrote in message
...
I am doing a catalog merge in publisher. Data is in XL. Publisher has 255
character limit on merged info. How do I count the characters before I
execute the merge?