Join Dennis Taylor for an in-depth discussion in this video Remove leading single quotes, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] Sometimes when you get data…from another source, you might see numbers…that have a single quote in front of them.…Any number of obscure reasons for this,…but when we deal with situations like this,…sometimes it's confusing.…And there's a visual on the screen right now…that you might not be seeing.…Let me zoom in on the data first…and click one of these cells here…and let's look in the Formula bar…and we see a single quote.…If you happen to double-click in a cell,…you will also see there's single quotes here.…And we don't want them there.…Are these numbers?…I want to say yes and no.…
First of all, let's format them.…Column A, let's click the entire column.…On the Home tab, let's simply put in a comma here,…it'll be helpful to see commas there.…And what happens?…It shifts the data around a little bit,…but it doesn't apply commas.…Does it apply currency?…Doesn't do that either.…Go back to comma, it's not doing anything, really, is it?…Could we go into other formats?…Display these by way of the number tab here,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes