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

2017-12-23 Thread Aamir Shahzad
​this formula is already applied, but I want to enter formula automatically because i have data from A1 to HA1 and get data into B1 On Sat, Dec 23, 2017 at 6:57 PM, Prabhu Pinky wrote: > If you have those values in A1,B1,C1. Then put formula in D1 as =A1&B1&C1. > > On 23-Dec-2017 3:09 PM, "Aamir

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

2017-12-23 Thread Prabhu Pinky
If you have those values in A1,B1,C1. Then put formula in D1 as =A1&B1&C1. On 23-Dec-2017 3:09 PM, "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$$ concatenate in one cell

2017-12-23 Thread Kishore P V K
If I understand correctly, you need the excel data in a csv format. If that is the case save the file as .csv file. On Saturday, December 23, 2017, Aamir Shahzad wrote: > Friends, > > I want to concatenate all below data in one cell without any space. > Formula please. > > data > 148351, 183776,