I would like to modify this macro to insert a string character after encountering the first non-blank character in a column.
example: my data is in col A (The row count varies)
----------
"When working in Excel, you can often undo the actions "
"you must change it so that it references the directory "
disabled when saving a workbook
Pay special attention to range
You must click the Enable option in the yellow
I would like the output to be
"Insert HereWhen working in Excel, you can often undo the actions "
"Insert Hereyou must change it so that it references the directory "
dInsert Hereisabled when saving a workbook
PInsert Hereay special attention to range
YInsert Hereou must click the Enable option in the yellow
My current code
Bookmarks