Getting rid of leading single quotes


show more Getting rid of leading single quotes provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data show less
please wait ...

Getting rid of leading single quotes

Downloaded or copied data might contain leading single quotes. And although generally not a problem, you do want to get rid of them. There are a couple techniques for doing this. We don't see them so obviously either. In Column B there are some, and as I click on Cell B3, you can see in the formula bar there's a single quote. If you happen to double-click in the cell, you'll also see it there too. We don't have these on all the cells, but we don't know how many, and we are certainly not going to go to every single cell to check it out. We need to get rid of them though, for the sake of consistency, and potentially some other reasons as well.

One way to approach this is simply to use a function called Substitute. I'll make the column a little bit wider here, so we can see this better. We simply want to substitute for that single quote if it exists, nothing. The substitute function allows us to do this, regardless of where it's found, but in this case it will on...

Getting rid of leading single quotes
Video duration: 3m 0s 1h 28m Appropriate for all

Viewers:

Getting rid of leading single quotes provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data

Subjects:
Business IT
Software:
Excel
Author:
please wait ...