Using the concatenate function, I get the correct formula result in the
formula window but once I say OK it displays the formula itself on the cell
not the result...I am trying to combine text and numbers (an address) and it
is just not working...HELP!

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.