Can Numbers merge columns? If so, how? I need to import some data into a 3rd party software but my Numbers file has the first and last name in separate columns while the 3rd party software needs the first and last name to be in one combined field for their import.
You could use an additional column to concatenate 2 columns. For instance if cell A1 contains the first name, B1 the last name, the following formula in C1 would display both names:
A1 & “ “ & B1
You could use an additional column to concatenate 2 columns. For instance if cell A1 contains the first name, B1 the last name, the following formula in C1 would display both names:
A1 & “ “ & B1
Merging Columns In Numbers