Hi Kevin,
Here the macro...
Feedback please...
Kind Regards,
Paul Willekens
'===
Sub Reformat()
Dim cAddress
Dim cCity
Dim cCompany
Dim cEmail
Dim cName
Dim cPhone
Dim cState
Dim cTitle
Dim nPos
Dim nRowIn
Dim nRowOut
nRowIn
Excel-Macros$$ Excel Spreadsheet Cleanup
To: excel-macros@googlegroups.com
Hi there,
I hope this is enough...
On Thu, Apr 15, 2010 at 9:13 PM, Dave Bonallack
wrote:
Hi,
This sort of data can usually be "cleaned up" automatically.
You will need to attach a workbook that
Hi there,
I hope this is enough...
On Thu, Apr 15, 2010 at 9:13 PM, Dave Bonallack
wrote:
> Hi,
> This sort of data can usually be "cleaned up" automatically.
> You will need to attach a workbook that contains a few addresses in their
> current form, and at least one address in the format you'
Hi,
This sort of data can usually be "cleaned up" automatically.
You will need to attach a workbook that contains a few addresses in their
current form, and at least one address in the format you'd like it to be. I'm
sure one of us will be able to help you once we see this.
Regards - Dave.
