Hello! I have a question... My coworker and I use an Excel workbook filled with VLOOKUP functions to pull a list of phone numbers from a raw datasheet into a cleaner interface.
Our thing is, we need a way to mark that the number is verified. We were thinking adding an asterisk at the end of the number to mark it as verified.
The problem is, that messes with the phone number format "(555) 555-5555", which then forces it to look like, "5555555555*
How can we make it look like this, "(555) 555-5555*"?
Thanks!
Bookmarks