RE: Excel Data
You might try using the find and replace feature in Excel. Unfortunately,
you will have to do each different form seperately i.e., FITZPATRICK Mick
and then Fitzpatrick,Mick. Choose Edit, Replace and type in FITZPATRICK
Mick (If you don't choose match case, it won't make any difference if you
capitalize or not). Then type in MICK FITZPATRICK (all caps if that is the
way you want it to appear) and choose the replace all button. Repeat the
process for Fitzpatrick,Mick.
Hope this helps you,
Darlene
PCSOFT maintains many useful files for download
on our web site - visit our download page at:
http://nospin.com/pc/files.html
|