I work with mailing lists in Excel that need to be cleaned up.
I need to have the following search and replace done (being careful that it doesn't remove them from actual words)
a. DR = Drive
b. ST = Street
c. LN = Lane
d. BLVD = Boulevard
e. RD = Road
f. HOLW = Hollow
g. CT = Court
h. TRL = Trail
i. PTH = Path
j. CRK = Creek
k. PL = Place
l. BND = Bend
m. CV = Cove
n. AVE = Avenue
I need columns to have the case set to Proper. For example there will be some words in ALL CAPS - I want to be able to highlight an entire column and have the words set to Proper Case.
I want to have some keystroke macros created to cut and paste highlighted words from one cell to another.
The final product must work when I upload it to my application (meaning if any functions are used and there is not an actual value - if this is a problem. We'll need to solve it.
I will provide actual lists of data once I've selected a provider.
For anyone used to macros in Excel - this should be very easy.