I'm importing information from two different DB's into excel spreadsheets. The information from both systems should be the same, but differ because of one minor problem. In data base #1 the information that I'm importing into the spreasheets is listed below:
BC-45678
AC-12345
CD-23456
RD-34567
The information from data base #2 that is being imported is listed below:
BC45678
AC12345
CD23456
RD34567
How can I format the column in the first speadsheet (BC-45678) to remove the hyphen w/o having to re-type all 30,000 entries that have been imported into the spreadsheet?
T.
BC-45678
AC-12345
CD-23456
RD-34567
The information from data base #2 that is being imported is listed below:
BC45678
AC12345
CD23456
RD34567
How can I format the column in the first speadsheet (BC-45678) to remove the hyphen w/o having to re-type all 30,000 entries that have been imported into the spreadsheet?
T.