Forum Home
Press F1
 
Thread ID: 61131 2005-08-25 12:21:00 How to change key field data tvg70 (2047) Press F1
Post ID Timestamp Content User
383671 2005-08-25 12:21:00 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
tvg70 (2047)
383672 2005-08-25 21:59:00 Good site for answers to excel questions.
www.mrexcel.com
hth
johnboy (217)
1