Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creation for name formating
I have very little knowledge of VB. I am trying to write a Macro that will
change the formating of names in a particular column. This is the data currently: Last, first initial (ex Trolian, Jason A - or - Trolian, Jason Alan) The examples show that not all names are the same and in some cases there is no middle initial or middle name. The end result that I am trying to reach is 3 columns "First" "Middle" "Last" If anyone can help we with this it would be greatly appreciated. In the past I would convert to CSV file and use the comma in the name as a delimitor. With small amounts of records this is ok but for my purpose now I will be modifying 17,000 records. Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creation of macro with an example | Excel Discussion (Misc queries) | |||
Macro Creation | Excel Discussion (Misc queries) | |||
Macro Creation | Excel Programming | |||
XML creation via a macro | Excel Programming | |||
Macro Creation | Excel Programming |