If I understand what you want to do, you could use the concatenate function. Just insert a new column and use concatenate to add "abcd" to the contents of the existing column. Then you could need to "copy" and "paste special...values" into a third column. Delete the original column and your "concatenate" column. -- Motorola Canopy 900MHz|Linksys/DD.WRT-Vista/XPPro/Ubuntu