| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract number from a cell
On Wednesday, June 14, 2017 at 11:07:02 AM UTC-4, Paul Doucette wrote:
I need to extract a number from a sting of characters in column A to column B. The format of the string "within quotes" examples and the desired result "=" below: colA colB "b1 c 3" = $1.00 "e15 d 12" = $15.00 "eff1.25 c" 15" =$1.25 "b3.75 c 6" =$3.75 "f2.5 c 1" = $2.50 "e1.33 c 12" = $1.33 "b1.2 c 3" = $1.20 "b4 c 2" = $4.00 "db5 c 1" = $5.00 "b1 h 2" = $1.00 The format of the string in column A is first a 1, 2, or 3 letter code followed immediately by the number I need to extract to column B and then a space after that number. (That space is then followed by a letter, a space, and then another number.) Looking for the correct formula for column B to achieve the result. Thanks in advance! Thank you Claus! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract everything to the right in cell when a number is encounter | Excel Worksheet Functions | |||
| how do i extract a number from a cell with no spaces? | Excel Worksheet Functions | |||
| Extract sheet name/number to cell | Excel Discussion (Misc queries) | |||
| how to extract the row number of a cell with certain value | Excel Programming | |||
| Extract number from name of cell | Excel Programming | |||
Threaded Mode
