Excel Spreedsheet Formating and Macro

CLOSED
Bids
29
Avg Bid (AUD)
$60
Project Budget (AUD)
$30 - $250

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.
to
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:
Data Entry, Data Processing, Excel
Additional Files: freelancer.jpg
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 0 days
$ 66
in 0 days
$ 30
in 0 days
$ 69
in 2 days
$ 61
in 2 days
$ 120
in 3 days
Hire rajeshsonisl
$ 250
in 1 days
Hire macejd
$ 60
in 2 days
$ 33
in 0 days
$ 80
in 2 days