I have a bunch of data that looks like this
abc, def, 123, ghi
The lengths of each string aren't consistent line over line. If an entire worksheet was like this I'd just go to Data/CSV and open it like that but this is just a small range.
How would I separate values that are currently separated by commas into 4 different fields?
abc, def, 123, ghi
The lengths of each string aren't consistent line over line. If an entire worksheet was like this I'd just go to Data/CSV and open it like that but this is just a small range.
How would I separate values that are currently separated by commas into 4 different fields?