My Excel spreadsheet has a column with room numbers, i.e. 101, 102, 2A, 2B, etc. When merging these numbers into a Word document, the room numbers that include alpha characters are completely ignored as if they do not exist. The room numbers such as 2A, 2B, etc. are unrecognized in merging simple data and in "IF" statements. I have tried formatting my cells to General, Text, Number (even using the formula x1), and creating a Special format. I do not get any error messages and everything works fine with the regular room numbers. Any help would be greatly appreciated. Thanks!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!