Merge data from 2 cells in one

N

nick

Hello all

How can I automatically merge data stored in 2 columns, in
one new column?

Thanks in advance

Nick
 
M

Max

Assuming your "merge" means combine text in 2 cols A & B, then

In C1: =TRIM(A1&" "&B1)
Copy down col C
 
Top