Excel Spreedsheet Formating and Macro

This project received 29 bids from talented freelancers with an average bid price of $60 AUD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

see file attached for reference.

I need the following done. On the attachment the data with no fill is the original and the couloured filled rows are what i need it turned into. I don't require the original to remain in the document.

Excel Version 2007

I need a macro or code for a rule to do the following.

> Delete rows that dont contain the key phrashes in column B "Extension" or "House in DPC"

> Create a new column with the content from column c formatted from the below

"number" "street name" "type" "suburb" "state" "post code" please note they will always appear in this order when copied in, there will not be any extra or less.


Column C > "number" "street name" "type" (Formatted with first letter of each word as a capital)

Columb D > "suburb" "state" "post code" (formatted with capital letters)

That date that appears in column D should also be deleted as it is not required.

Looking to hire asap.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online