View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HBj[_2_] HBj[_2_] is offline
external usenet poster
 
Posts: 9
Default Formatting string in groups of letters...

Hi,

How can a string without spaces be formatted to display the string in groups
of five characters.
Example:

246 81357 99876 54321

Only the left-most group can contain less than 5 characters

--
Håkan