Originally Posted By: pdacey This post was automatically imported from our archived forum.
Is there anyway to suppress certain information in a cell? like all numbers or all letters?
For example:
If I have an address entered in a cell (123 Oak Street), is it possible to suppress the numbers so only "Oak Street" will be visible and vice versa?
Originally Posted By: kmcmahon This post was automatically imported from our archived forum.
I don’t think so…but you can just create another column of cells. In one cell column put the number address and in the second column of cells put the letter address.
Originally Posted By: pdacey This post was automatically imported from our archived forum.
That’s what I do but when I copy the addresses from the internet, the number is in the same cell as the street name. So I have to do a lot of editing. I’m just looking for a quicker way to edit the info.