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?