Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula in Excel / Replace numbers with 'words' | Excel Discussion (Misc queries) | |||
HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003? | Excel Discussion (Misc queries) | |||
How can I change Numbers in WOrds in Excel | Excel Discussion (Misc queries) | |||
how to change numbers into words, | Excel Discussion (Misc queries) | |||
How do I make my settings suggest previous words as I start to ty. | Excel Discussion (Misc queries) |