| 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. |
| 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) | |||
Threaded Mode
