| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting numbers from a string containg letters at the end
Thanks Rick,
best regards, Roger "Rick Rothstein" wrote: Oops, I missed the second part of your question. Assuming your first value is in A1 and you put the formula I gave you in B1, then put this in C1... =TRIM(SUBSTITUTE(A1,C1,"")) By the way, my earlier posted formula and this one can be copied down as needed. -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... Give this formula a try.. =LOOKUP(9.9E+307,--LEFT(A1,ROW($1:$99))) -- Rick (MVP - Excel) "Roger on Excel" wrote in message ... I have a column of cells which contain material quantities in units of grams (g) or millilitres (ml). I need to extract the numbers from the strings and paste them into the adjacent cell. It would also be nice to place the unit in the next cell afterwards also For example: 3.04g 25ml 24.2 ml 5 g 3g Notice that there sometimes is a space after the number which would need to be removed. Can anyone help? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting numbers and letters in a single cell to separate cells | Excel Discussion (Misc queries) | |||
| Extracting Numbers from string | Excel Worksheet Functions | |||
| Extracting numbers from string of text | Excel Discussion (Misc queries) | |||
| Splitting string into letters and numbers | Excel Programming | |||
| extracting numbers from string | Excel Discussion (Misc queries) | |||
Hybrid Mode
