Hi,
hoping someone could help me with the vba code for text to column but split using the first space only. Eg, John Sam Smith, I want to split using only the first space after John, ignoring the second space (and other spaces for extra text), eg result: "John" and "Sam Smith"
below code split using all spaces:
Selection.TextToColumns DataType:=xlDelimited, Space:=True
Thanks,
Joey
hoping someone could help me with the vba code for text to column but split using the first space only. Eg, John Sam Smith, I want to split using only the first space after John, ignoring the second space (and other spaces for extra text), eg result: "John" and "Sam Smith"
below code split using all spaces:
Selection.TextToColumns DataType:=xlDelimited, Space:=True
Thanks,
Joey