Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but the format of that imported data can vary drastically from one source to another.
For example, fields may be delimited, such as with tabs, spaces, commas, or periods. Aany other characters are all preferable to spaces. That’s because spaces not only exist in between fields, they also separate words within the fields, which makes sorting out the fields a real challenge. That’s where the following Text functions are very helpful.
A. Use the SUBSTITUTE function to replace one string of text with another
Function syntax: The syntax (or sentence structure) of the SUBSTITUTE function is this:
To read this article in full, please click here