I want the data in two columns need to be in one column without lossing data
D Duke Carey May 27, 2005 #2 If it's text values, =A1&B1 or, if you want a space between them =A1&" "&B1