[SOLVED]Remove Leading Apostrophe

[eyeball11]

Hi Folks,

I have some data that is coming up as having a lead apostrophe. How do I remove that from multiple cells simultaneously?

[Ron Coderre]

Try this:
• Select you single-column range of cells to be impacted
• Data.Text-to-columns...Click: Finish

Does that help?

If NO...we'll probably need some sample data or a sample workbook to play with.

[eyeball11]

Try this:
• Select you single-column range of cells to be impacted
• Data.Text-to-columns...Click: Finish

Does that help?

If NO...we'll probably need some sample data or a sample workbook to play with.

Awesome! Thanks, it worked. I've had that problem before and never knew of that function.