If your text records are missing some values, you can insert them in no time with the Add Substrings feature from Substring Tools. Let the add-in know what and where to add and enjoy the work done.
Here are the things to keep in mind:
To start working with the Add Substrings tool, click the Substring Tools icon on the Ablebits Data tab and opt for Add Substrings:
The tool pane will show up:
Here is the example:
To process your data, click the Add button. After the work is done, the tool will let you know how many cells it has modified:
I do not see the substring option under Ablebits Data.
Please make sure to download and install the most recent version of the add-in using this link: https://www.ablebits.com/files/get.php?addin=xl-suite
Then check if the tool became available for you. Thank you.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!