D
Danno 24/7
Hi
I need to be able to enter a text abbreviation to represent a client address
in a cell for it to return the full address in the same cell
ie
If I type MD in cell A1 it will return MacDonalds, Unit 5............etc in
the same cell
I have a database sheet which is referenced for the full address and use the
IF formula to locate the correct address from the abbreviated text.
I need to be able to enter a text abbreviation to represent a client address
in a cell for it to return the full address in the same cell
ie
If I type MD in cell A1 it will return MacDonalds, Unit 5............etc in
the same cell
I have a database sheet which is referenced for the full address and use the
IF formula to locate the correct address from the abbreviated text.