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.
CELL A1=  we 
CELL A2= live 
CELL A3= in
CELL A4= UK
From above I want to get the all text line , in the CELL B1 like below 
CELL B1= We live in UK
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 .