lkirke
asked on
Macro to find multiple values within a text string of a column then insert tab spacer
Hello experts,
I would like to have a macro that finds a range of specified values within a text string then insert a tab spacer.
For instance, I have rows of data within column A. For every instance of the text string "Text Line" or "Data Info", I would like to insert a tab spacer between the word Text and Line, as well as Data and Info.
Please find attached an example as a illustration.
Could anyone provide some assistance?
Regards
EE-Example-Tab-Spacer.xlsm
I would like to have a macro that finds a range of specified values within a text string then insert a tab spacer.
For instance, I have rows of data within column A. For every instance of the text string "Text Line" or "Data Info", I would like to insert a tab spacer between the word Text and Line, as well as Data and Info.
Please find attached an example as a illustration.
Could anyone provide some assistance?
Regards
EE-Example-Tab-Spacer.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER