Help with to create a VB Code

[udprocks]

Hi Sir.

Is this possible to create a VB code in excel ? please see below

delete certain unwanted data in Column A and replace it with what I need. In addition, if there is no data to delete I need it to simply add on to the existing data. It's very important that it skips any cell within that column, that does NOT have data.

Ex. 123 Main, DA I would want the "DA" removed and add " , Dallas, TX"
Ex. 123 Main I would want it too add ", Dallas, TX"

I will need a drop down menu to select what I want inputted into each cell, between a few choices.

1. , Dallas, TX
2. , Fort Worth, TX
3. , Arlington, TX

Thanks in advance,

 

[vletm]

udprocks
It's possible...
but with those informations,
but You maybe need to make some modifications to somewhere (Your file)
if someone would do the code for You.
> Upload a Excel file which has all needed rules
which You need
including enough samples <