View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Viking Viking is offline
external usenet poster
 
Posts: 8
Default Need help with Text to Column in a macro.

I am hoping that someone can offer help with this matter.

I have the following text that I need to break into separate columns to
get the sentences separated:
"1.2.3 This is an example. That I need to break down"

What I get when I do a texttocolumn using the "." as the separator:
"1" "2" "3" "This is an example" "That I need to
break down"

What I am trying to get is:
"1.2.3" "This is an example" "That I need to break down"

Is there someway of breaking the "1.2.3" out first?

Thanks for any help.
Troy Vincent