I've got string data in the first (A) column of a spreadsheet. Each string
consists of comma separated substrings. I'd like to distribute the
substrings out into their own columns, e.g., if An contains
"hi,there,my,name,is", I'd like to put "hi" into Bn, "there" into Cn, "my"
into Dn,"name" into En,"is" into Fn. It is easy to do this manually, but
when I use the Macro Recorder to get the code to do it, the code doesn't
work. Can anyone help?
Thanks,
Kerry Soileau