$$Excel-Macros$$ Re: concatenate in one cell

But this will work, but you need select each cell manually. Thanks, David =TRIM(CONCATENATE(A2,B2,C2)) On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote: > > Friends, > > I want to concatenate all below data in one cell without any space. > Formula please. > > data > 148351

$$Excel-Macros$$ Re: concatenate in one cell

I can not think of another way. Good luck, David On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote: > > Friends, > > I want to concatenate all below data in one cell without any space. > Formula please. > > data > 148351, 183776, 032290, > > result > 148351,183776,032290 >

Re: $$Excel-Macros$$ Re: concatenate in one cell

this is manual formula & need select cells one by one I want to use entire range e.g. A1:HL1 On Mon, Dec 25, 2017 at 4:40 AM, who wrote: > =trim(C4)&trim(D4)&trim(E4)&trim(F4)&trim(G4) > > Try the above, assuming the data is in the addresses used. > > Thanks, David > > On Saturday, December 23,