I have a excel spreadsheet with 23 tabs. Each tab has multiple business addresses listed. However these addresses have some information that i want removed. I need someone to go through each tab and each line and remove the following information from the address cell so there just the business address left.
-the word 'headquarters'
Split each address over three columns A,B,C
A = Street Building Number/Name (eg 73b Elizabeth St )
B = City/Area, State, Postcode (eg Wetherill Park, New South Wales, 2164 )
C= Country (eg Australia)
Each tab has an ID number. This must remain in place.
28 freelancers are bidding on average $109 for this job
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]