i want to split a range of cells(E) into words in another column (G). There are two problems:
1) the cell contains paragraphs and a new line is not taken as a delimiter. only the first line of each cell gets split
2) They get split into all columns after G . I want all the words in one column. The code I used is as below pls help
1) the cell contains paragraphs and a new line is not taken as a delimiter. only the first line of each cell gets split
2) They get split into all columns after G . I want all the words in one column. The code I used is as below pls help
VBA Code:
Sub splitting()
Range("E1:E20").TextToColumns Destination:=Range("G1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False
End Sub
