Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
text column - via macro | New Users to Excel | |||
Macro for text to column | Excel Discussion (Misc queries) | |||
Text to column macro | Excel Discussion (Misc queries) | |||
Macro delimiting text if column has value | Excel Programming | |||
text to column macro | Excel Worksheet Functions |