$$Excel-Macros$$ Re: Get Numeric Values in a Column

Hi Mandeep, This data has a pattern All Product Ids are right side of (P_ ) or (S_) , so is it possible to extract numbers only which is on the right side of these pattern. or Data extract from right ti left and stop when _P_ or _S_ found and start next cell to extract. For example: ELC_COM_

$$Excel-Macros$$ Re: Get Numeric Values in a Column

Hi Mandeep, This data has a pattern All Product Ids are right side of (P_ ) or (S_) , so is it possible to extract numbers only which is on the right side of these pattern. or Data extract from right ti left and stop when _P_ or _S_ found and start next cell to extract. For example: ELC_COM_

$$Excel-Macros$$ Re: Get Numeric Values in a Column

Thanks Mandeep... On Friday, July 17, 2015 at 5:54:42 PM UTC+5:30, Mandeep Baluja wrote: > > check this out >> > > > Check this Out. > > Regards, > Mandeep Baluja > Email :-mandeep...@snapdeal.com > mandeep...@gmail.com > https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 >

$$Excel-Macros$$ Re: Get Numeric Values in a Column

0).Row > Range("B" & lr).Resize(rowsize:=UBound(v) + 1) = Application.Transpose(v) > Next > > End Sub > > > > > > > > > > > > > > > On Friday, July 17, 2015 at 4:35:52 PM UTC+5:30, Mahendra Verma wrote: >> >> Hi Sir, >> >&

$$Excel-Macros$$ Re: Get Numeric Values in a Column

Hi Sir, Getting same error. May you please share coding and process that would be helpful for us. On Friday, July 17, 2015 at 4:26:26 PM UTC+5:30, Mandeep Baluja wrote: > > Try to download this file > > On Friday, July 17, 2015 at 4:23:43 PM UTC+5:30, Mahendra Verma wrote: >&

$$Excel-Macros$$ Re: Get Numeric Values in a Column

+5:30, Mandeep Baluja wrote: >>> >>> Where is the error I am not getting the same in this sheet !!, Kindly >>> provide the snapshot. >>> >>> On Friday, July 17, 2015 at 1:40:30 PM UTC+5:30, Mahendra Verma wrote: >>>> >>>> Gettin

$$Excel-Macros$$ Re: Get Numeric Values in a Column

gt; provide the snapshot. > > On Friday, July 17, 2015 at 1:40:30 PM UTC+5:30, Mahendra Verma wrote: >> >> Getting below error: >> >> >> <https://lh3.googleusercontent.com/-r3AoHmozD_E/Vai4XHaYtyI/BL0/j7e-jKtapc4/s1600/error.png> >> >>

$$Excel-Macros$$ Re: Get Numeric Values in a Column

Getting below error: -- 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/disc

$$Excel-Macros$$ Get Numeric Values in a Column

Hi All, I have problems with Campaign names contains Multiple Product IDs separated by (_) like ( *Campaign_Name_p_34876_9887_0989_87_6668789_576878*). I need output as below: 34876 9887 0989 87 6668789 576878 Please find attached file and below Snapshot as reference: