Split cell with comma, into new worksheet
Hi
I am trying to do a text - column format but to pull into a new sheet.
e.g.
In DWH Dump A13 = Nokia, 6230
I want it to pull 'Nokia' into Sheet 1 A11 and '6230' into Sheet 1 B11.
If you can help, I would be grateful.
Many Thanks,
Greg
|