I have been given a spreadsheet full of employee IDs - someone placed a ' in front of all the IDs however and management wants that removed (I'm thinking someone did it so zeros would show) - is there a mass way to remove the ' from all IDs and have zeros always show also? Thx : ) I did try the find/replace but it doesn't find the ' when searching.