In Progress

Excel Macro

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.

Skills: Excel, Visual Basic

See more: blvd boulevard excel macro, excel macro caps, we excel, trl, cv example, n excel, my j, st place, road, remove b, pth, macro upload, macro excel, macro e, ln, lane, keystroke, highlight, Dr, data upload excel, ct, court, ave, excel mailing, macros excel basic

About the Employer:
( 7 reviews ) Austin, United States

Project ID: #216675

Awarded to:

xamdam91

Looking forward to working with you.

$50 USD in 0 days
(62 Reviews)
6.1

34 freelancers are bidding on average $70 for this job

best4best

Please see PMB.

$60 USD in 2 days
(72 Reviews)
5.2
iDivya

Hi, Please read my message...

$50 USD in 2 days
(27 Reviews)
4.9
johnsinit

Dear jallen919! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB.

$38 USD in 3 days
(16 Reviews)
4.2
hiratariq

Please see PM

$70 USD in 2 days
(8 Reviews)
4.0
minyun

Hi. I have much in same task. Please let me help you. Thanks

$100 USD in 2 days
(7 Reviews)
4.1
Abikris

Check PMB. Thank you.

$30 USD in 1 day
(5 Reviews)
2.5
hiipandit

plz check PMB

$50 USD in 2 days
(2 Reviews)
2.2
kmohan1962

Hello; I'm right away ready to fix this small routine. Regards.

$80 USD in 1 day
(3 Reviews)
0.9
harishmaster

Please check PMB

$100 USD in 5 days
(0 Reviews)
0.0
pioneer2008

I can produce the desired results with 100% accuracy.

$50 USD in 2 days
(0 Reviews)
0.0
sxghosh

Requirement is detailed. But there needs to be some clarifications like a) What do you mean by "PROPER" case, Is it init caps b) What short keystrokes you require. Need bit of clarification I will be able to deliv More

$30 USD in 1 day
(0 Reviews)
0.0
sunikutty

I m intrested in your project.

$75 USD in 3 days
(0 Reviews)
0.0
carlestops

Hello I have updated myself to GOLD juSt to serve you I already have it for you!!! see my attachment.

$30 USD in 1 day
(0 Reviews)
0.0
smith786

i have 2+yrs of experience in excel and macro , where quality meets speed

$49 USD in 0 days
(0 Reviews)
0.0
dkayshev

I can finish it off very easily. I had done similar jobs like this........ Expecting your favourable reply, thanks

$221 USD in 3 days
(0 Reviews)
0.0
ipruadviser

I can do this, I have sufficient experience in this field with 100% accuracy.

$150 USD in 1 day
(0 Reviews)
0.0
piekna

I have a 9 year experience in Excel and VBA. Glad to help you. Have some questions about project - see pmb, please

$30 USD in 1 day
(0 Reviews)
0.0
bsoist

Please see PMB.

$50 USD in 1 day
(0 Reviews)
2.0
koushiksen

we can deliver this in four days charges usd 250

$250 USD in 4 days
(0 Reviews)
0.0
pwenghon

Hi Sir, I would like to do this job. I have better way to solve your problem.

$50 USD in 3 days
(0 Reviews)
0.0