Thread: Convert string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel ESG Excel ESG is offline
external usenet poster
 
Posts: 11
Default Convert string

Hello,

I have a string wich I want to convert.
All spaces should be replaced by an underscore,
and an (alt-enter) should be inserted after an underscore so that the string
is wrapped to a max length of 13 characters

e.g "Thanks very much in advance" should result in

Thanks_very_(Alt-Enter)
much_in_(Alt-Enter)
advance

Someone told me it should be possible with an UDF,
but I have no experience with that