Hi all,

Note: in VBA and not using Excel's built in functions

Quite simply (she says), I want to capitalise a person's name (fo
example).
So an example might be that Range("A1") contains the name 'mr john ala
smith'. Using VBA , I would want this string replaced with 'Mr Joh
Alan Smith'.

My program basically inputs a text file, seeks out the lines tha
contain contact details and I want to tidy up the lines prior t
populating a spreadsheet.

In the following example, let's assume the following is the text I nee
to format/ tidy up.

1) mr John aLAN smith,
2) 10b the Crescent
3) norwich.
4) England

Line 1 would become Mr John Alan Smith
Line 2 would become 10b The Crescent
Line 3 would become Norwich
Line 4 would become England

Has anyone already written a little routine that will work its wa
through a string doing the necessary on route like removing fullstops
capitalising where expected, etc?

Anyone's help would be much appreciated

Thanks

Rie

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com