Make words imported into numbers, ex SMRC=303
 

I have 3 different groups of letters. SMRC, SMIF and SMBD that I am importing
into excel. The spreadsheet that I am using that was built a long time ago
has me manually changing these to numbers. I would rather be able to make a
formula then copy and paste these into the right spot rather than doing each
one manually for over 2000 entries.

SMRC=303
SMIF=373
SMBD=383

If anyone can help that would be great.

Thanks

Bobby.

Make words imported into numbers, ex SMRC=303
 

Have you tried EditReplace...? It should do what you want.

--
Regards,
Fred


"mulligbo" wrote in message
...
I have 3 different groups of letters. SMRC, SMIF and SMBD that I am importing
into excel. The spreadsheet that I am using that was built a long time ago
has me manually changing these to numbers. I would rather be able to make a
formula then copy and paste these into the right spot rather than doing each
one manually for over 2000 entries.

SMRC=303
SMIF=373
SMBD=383

If anyone can help that would be great.

Thanks

Bobby.

Make words imported into numbers, ex SMRC=303
 

Try this,
In the cell to the right of the top entry in your list enter;
=IF(A7="SMRC",303,IF(A7="SMIF",373,IF(A7="SMBD",38 3,"")))
where A7 is the top cell in your list.
Then copy this formula down the length of your list. Now you can copy and
paste special (values and source formatting) the new list of numbers to where
ever you want.

"mulligbo" wrote:

I have 3 different groups of letters. SMRC, SMIF and SMBD that I am importing
into excel. The spreadsheet that I am using that was built a long time ago
has me manually changing these to numbers. I would rather be able to make a
formula then copy and paste these into the right spot rather than doing each
one manually for over 2000 entries.

SMRC=303
SMIF=373
SMBD=383

If anyone can help that would be great.

Thanks

Bobby.