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.