| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select the first number/numbers in a cell input into another colum
I have a description cell that has variable alphanumeric characters. the
first one to two numbers I would like to copy to another column for the size of the description i.e. AA_NAAAa NNN AA N. The number I want is the first number unless the description shows AANNANN NNNN aAa n, I would want the first two numbers. these numbers indicate the size of the material. I don't know if a macro and/or a function would be the best way to go. -- Sue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I select a number from a specific group of numbers? | Excel Worksheet Functions | |||
| How do I input numbers used to select cells in several columns | Excel Discussion (Misc queries) | |||
| Select cell from range based on input in excel xp | Excel Discussion (Misc queries) | |||
| Set a formula to always select the last value present in a colum | Excel Worksheet Functions | |||
| How do I enter a prefix number to a colum of numbers | Excel Worksheet Functions | |||
Threaded Mode
