Re: $$Excel-Macros$$ Combining a Mid Function and Right Function into one statement

Hi, Use Text to Column Method separated by "_" after that use concatenate formula to combined them. Thanks Veera On Thu, Mar 26, 2015 at 8:15 AM, Ashish Kumar wrote: > Hi Mychele, > > PFA > > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’

Re: $$Excel-Macros$$ Combining a Mid Function and Right Function into one statement

Hi Mychele, PFA Regards Ashish -- 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 thread titles, like

$$Excel-Macros$$ Combining a Mid Function and Right Function into one statement

I need to combine to functions into one. I need to trim off the F_ from the left side of the column and I need to look if there is a _F on the right side of the column. Example of data I need to trim F_ACQ_SUP_F Would need to look like this cleaned up ACQ_SUP I have the function working to c