Link to home
Start Free TrialLog in
Avatar of lkirke
lkirkeFlag for Australia

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
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lkirke

ASKER

Fantastic. Thank you Ryan.