December 14, 2017 CuttingEdgeTech 0Comment

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

Powered by WPeMatico