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
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.
2 Replies
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!
