Dear all, I am having multiple text line in the column A , now I want to get each line in the cell B1 & there is a space between each line.
From above I want to get the all text line , in the CELL B1 like belowPlease Login or Register to view this content.
i can do it by concatenate but the cell range of column A is not fixed , some time the range as A1:A200 . for this need macro solution .Please Login or Register to view this content.
Bookmarks