hey guys ,
what is the procedure in vb 1.) in order to write a find and replace macro for a column(field name) example is to replace blanks with the word "none" and "LA" to "los angeles" for a column and 2.) another macro to set the format(datatype) for each column. In my case I will be using type general, date in format xx/xx/xx xx:xx , and number with 2 decimal places.

Thanks guys