Re: $$Excel-Macros$$ extracting numbers

In all but one of your examples, the number you want to extract appears right after the text "_POV_" for which you can use the following formula - =MID(A1,FIND("_POV_",A1)+5,1) It will extract ONE character AFTER the text _POV_ HTH On Thu, May 5, 2016 at 11:24 AM, Izhar wrote: > LOOK AT THE

Re: $$Excel-Macros$$ Plz Solve this

PFA. When you make other cells bold, be sure to hit the F9 button to re-calcualte. HTH On Thu, May 5, 2016 at 11:12 AM, Sushma David wrote: > Hi Champs, > > Please solve this query. > > > > Regards, > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,D

$$Excel-Macros$$ extracting numbers

LOOK AT THE QUESTION IN WORKBOOK THANKS IN ADVANCE -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thre

$$Excel-Macros$$ Plz Solve this

Hi Champs, Please solve this query. Regards, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor threa

$$Excel-Macros$$ Browsing through all open workbooks

Hi All, I am trying to browse through all open workbooks and assign their names to variables based on some pattern. Below is the code I have written: Sub Test() Dim wb As Workbooks For Each wb In WorkbooksIf Workbook.Name Like "*123*" Then DestinationFile = ActiveWorkbook.NameElseI

$$Excel-Macros$$ Client in Eden Prairie, MN need Systems Analyst// Only locals please

Hi Partners Looking for sharp “*technical systems analysts.”* Need folks who can sit with the developers and drive business requirements through to completion. Anyone who has come up from a development background is ideal! *Healthcare industry experience is also a desired plus!* Most of the appli