Spreadsheet: 888280d1738772622-how-can-you-extract-a-number-from-a-cell-with-both-strings-and-numbers-sample-data
Sheet: Sheet1

 | Journal Transaction | Part Number
 | ADJ-CST Part:04632 Ext.[NAME]
 | ADJ-CST Part:824.29211.DP1 Ext.[NAME]
 | ADJ-CST Part:824.29211.SH1 Ext.Cost:-1632.03USD
 | ADJ-CST Part:824.29211.L4 Ext.Cost:-713.44USD
 | ADJ-CST Part:824.29211.L3 Ext.Cost:-518.58USD
 | ADJ-CST Part:824.29211.L2 Ext.Cost:-3465.04USD
 | ADJ-CST Part:824.29211.L1 Ext.Cost:-3037.44USD
 | ADJ-CST Part:020020037 Ext.Cost:13.20USD
 | ADJ-CST Part:020030010 Ext.Cost:-65.04USD
 | ADJ-CST Part:172000040 Ext.Cost:-169.12USD
 | ADJ-CST Part:04105 Ext.Cost:-83.20USD
 | ADJ-PUR Part:01336 IV:1-720649/1
 | ADJ-PUR Part:022000060 IV:1-720649/2
 | ADJ-CST Part:011413007 Ext.Cost:-1.11USD
 | ADJ-CST Part:011436007 Ext.Cost:-0.13USD
 | ADJ-CST Part:014013380 Ext.Cost:-99.88USD
 | ADJ-CST Part:014060300 Ext.Cost:0.10USD
 | ADJ-CST Part:014060400 Ext.Cost:-17.33USD
 | ADJ-CST Part:014290400 Ext.Cost:100.96USD
 | ADJ-CST Part:014290600 Ext.Cost:-0.06USD
 | ADJ-CST Part:014350400 Ext.Cost:-1.26USD
 | ADJ-CST Part:014470400 Ext.Cost:4.04USD
 | ADJ-CST Part:014470600 Ext.Cost:-13.22USD
 | ADJ-CST Part:014500400 Ext.Cost:-1.86USD
 | ADJ-CST Part:018560200 Ext.Cost:41.66USD
 | ADJ-CST Part:10750 Ext.Cost:-94.01USD
 | ADJ-CST Part:04487 Ext.Cost:8.10USD
 | ADJ-PUR Part:020020037 IV:119131/1
 | ADJ-PUR Part:014013380 IV:033619800/3
 | ADJ-PUR Part:014060300 IV:033619800/4
 | ADJ-PUR Part:014290600 IV:033619800/7
 | ADJ-PUR Part:014470400 IV:033619800/9
 | ADJ-PUR Part:018540600 IV:033619800/12
 | ADJ-PUR Part:018560200 IV:033619800/13
 | ADJ-CST Part:172000040 Ext.Cost:-12.08USD
 | ADJ-CST Part:02426 Ext.Cost:0.46USD
 | ADJ-CST Part:021375125 Ext.Cost:-2.02USD
 | ADJ-CST Part:021500003 Ext.Cost:7.35USD
 | ADJ-CST Part:171375003 Ext.Cost:1.00USD
 | ADJ-CST Part:04436 Ext.Cost:-412.01USD
 | ADJ-CST Part:021500001 Ext.Cost:7.60USD
 | ADJ-CST Part:103375001 Ext.[NAME]
 | ADJ-CST Part:020080030 Ext.Cost:-33.14USD
 | ADJ-PUR Part:10518 IV:87943/3
 | ADJ-CST Part:031000040 Ext.Cost:-6.40USD
 | ADJ-CST Part:E15-25966-536 Ext.[NAME]
 | ADJ-CST Part:010611008 Ext.Cost:-48.64USD
 | ADJ-CST Part:011413007 Ext.Cost:-5.18USD
 | ADJ-CST Part:011435007 Ext.Cost:-2.55USD
 | ADJ-CST [NAME].Cost:-6.95USD
 | ADJ-CST Part:014350400 Ext.Cost:-1.26USD
 | ADJ-CST Part:014350600 [NAME]Cost:-4.62USD
 | ADJ-CST Part:014383360 Ext.Cost:-0.60USD
 | ADJ-CST Part:014470300 Ext.Cost:-71.55USD
 | ADJ-CST Part:014470600 Ext.Cost:-3.31USD
 | ADJ-CST Part:014470800 Ext.Cost:-16.61USD
 | ADJ-CST Part:018540400 Ext.Cost:-9.01USD
 | ADJ-CST Part:018540600 Ext.Cost:-35.48USD
 | ADJ-CST Part:018540800 Ext.Cost:-102.36USD
 | ADJ-CST Part:018541000 Ext.Cost:-15.20USD
 | ADJ-CST Part:018560800 Ext.Cost:-50.23USD
 | ADJ-CST Part:03188 Ext.Cost:-1.04USD
 | ADJ-CST Part:03472 Ext.Cost:-1.74USD
 | ADJ-CST Part:08988 Ext.Cost:-5.73USD
 | ADJ-CST Part:10751 Ext.Cost:-70.61USD
 | ADJ-CST Part:11123 Ext.Cost:-70.80USD
 | ADJ-CST Part:11127 Ext.Cost:2.48USD
 | ADJ-CST Part:11128 Ext.Cost:77.55USD
 | ADJ-CST Part:03496 Ext.Cost:-10.80USD
 | ADJ-PUR Part:824.24330.2A2 IV:88389/1
 | ADJ-PUR Part:824.24330.2A3 IV:88389/2
 | ADJ-PUR Part:824.29211.SH1 IV:260627/6
 | ADJ-PUR Part:04632 IV:260628/1
 | ADJ-PUR Part:02426 IV:1-724636/1
 | ADJ-PUR Part:01336 IV:1-724650/1
 | ADJ-PUR Part:103375001 IV:1-724650/3
 | ADJ-CST Part:01032 Ext.Cost:487.50USD
 | ADJ-CST Part:03469 Ext.[NAME]
 | ADJ-CST Part:08107 Ext.Cost:289.08USD