Forum Discussion
Solved
Data in column C to split to 3 columns C, D & E to another sheet.
Hi, I am new in using excel VBA. I can't figure out on how to split the data from Column C (Sheet 1) to go to Column C, D & E (Sheet 2) without the characters. Sheet 1 Sheet 2 ...
If you have Microsoft 365 or Office 2024, you can do this with a formula.
In C3 on Sheet 2:
=TEXTSPLIT(SUBSTITUTE(SUBSTITUTE('Sheet 1'!C3, "'", ""), """", ""), {"-"," "})
Change Sheet 1 to the real name of that sheet, then fill down.
If you have Microsoft 365 or Office 2024, you can do this with a formula.
In C3 on Sheet 2:
=TEXTSPLIT(SUBSTITUTE(SUBSTITUTE('Sheet 1'!C3, "'", ""), """", ""), {"-"," "})
Change Sheet 1 to the real name of that sheet, then fill down.
It worked!
Thank you!
