For example, that Cell might be B2. From there, use the substitute function to change the string in B2 to a new one. If you’re a beginner, then we must say Microsoft Excel can be a challenging ...

But SUBSTITUTE does much more. In the following example, we clean up and reformat telephone numbers to strip out all extraneous characters, then use Excel’s formatting to convert the numbers ...