Hello everyone,
I'm a little confused this morning. Here is the scenario:
Column A is formatted as text because I need trailing zero's to show up because I am dealing with part numbers. There is no apostrophe present in any cell in this column.
Column B has the formula ="'"&A2 because I need a single apostrophe in front of this number to paste in "general" format for vlookups.
Column C I use to paste the entire Column B as a "value" (formatted general), but instead I am given two apostrophes instead of one preceding the number.
Hopefully an easy fix. Any thoughts?
Bookmarks