Need a script for excel
Hello
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.
Example
Say Column A has 3 words on 3 rows
A1= "car"
A2= "software"
A3 = "ball"
Then the macro will insert 8 columns with
B1 = "c", B2 ="s", B3 ="b"
C1 = "a", C2 = "o", C3 = "a" etc...
Note
- 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
Thanks!
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.
Example
Say Column A has 3 words on 3 rows
A1= "car"
A2= "software"
A3 = "ball"
Then the macro will insert 8 columns with
B1 = "c", B2 ="s", B3 ="b"
C1 = "a", C2 = "o", C3 = "a" etc...
Note
- 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
Thanks!
Last Comment
sample as attached.
28738478.xlsx
28738478.xlsx
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Ryan Chong
Sorry but what I needed was a VBscript macro
Sorry but what I needed was a VBscript macro
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Open in new window
and dragdown and right accordingly.