Thread
:
Help Extracting Numbers formula
View Single Post
#
6
Posted to microsoft.public.excel.misc
Max
external usenet poster
Posts: 9,221
Help Extracting Numbers formula
3 days [in cell A1]
400 per day [in cell A2]
Maybe this, in A3:
=LEFT(A1,SEARCH(" ",A1)-1)*LEFT(A2,SEARCH(" ",A2)-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With Quote
Max
View Public Profile
Find all posts by Max