PDA

View Full Version : How to change key field data



tvg70
26-08-2005, 12:21 AM
How can I change a key field data from

CAT1-1
CAT99-1
DOG45-1
DOG45-2
DOG45-3
FISH234-1

TO READ

CAT001
CAT099
DOG045
DOG045#2
DOG045#3
FISH234

The above is sample data in the key that needs to be changed.

Has anybody any ideas of where I can go to find the infromation on doing this or can give some idea of how to go about doing this using either access of excel 2000.

Thanks
Terry

johnboy
26-08-2005, 09:59 AM
Good site for answers to excel questions.
http://www.mrexcel.com/board2/
hth