I need a script for excel that will do the following:
Column A of my spreadsheet contains a list of words
I need the script to insert as many columns as needed on the right and populate these columns with the individual characters of these words.
Say Column A has 3 words on 3 rows
A3 = "ball"
Then the macro will insert 8 columns with
B1 = "c", B2 ="s", B3 ="b"
C1 = "a", C2 = "o", C3 = "a" etc...
- font and style should stay the same as the starting words
- should also work if the startind data is not a word but a number