Hi,
I have two seperate spreadsheets of data, is possible to run a VLOOKUP from one against the other ?
I need to verify an account number and part of a name.
Thanks...
I have a spread sheet with account numbers (all 16 digits) they have a space every 4, is there an easy formuala I can use to remove spaces and just leave one space after the first four ie 1234...
Hi, Can anyone help me out with formulaes on Excel ? I have a spreadsheet with account number that are in various conatations, they are all 16 digits and I want them all to be 4 digits then a space...
