(this is also posted in general as I'm guessing that VBA isn't the only
option)

There are 2 columns of data, A, and B. A contains numbers and B
contains what these numbers stand for. These columns contain about 9000
rows of data.

How do I replace the data in column A with that in column B?

One method is to use find and replace, going down column A and
replacing them by hand for all 9000 rows:-

For example:

1 = Avon
2 = Devon
3 = UK
4 = USA

^ press ctrl+H, type in 1 in the find box, and Avon in the replace box.
Run and repeat replacing all instances in the database 9000 times.

Is VBA the only option, and if so how may I do so?

TIA if you can!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/