example before a b Sam 12 Luke 19 John 13 After a b Sam 12 Luke 19 John 13
P phreakenstein Aug 28, 2008 #1 example before a b Sam 12 Luke 19 John 13 After a b Sam 12 Luke 19 John 13
M MSweetG222 Aug 28, 2008 #2 Phreakenstien, Have you considered using "Text To Columns" using the "space" deliminter? Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _ :=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True Hope that helps.
Phreakenstien, Have you considered using "Text To Columns" using the "space" deliminter? Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _ :=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True Hope that helps.
