OK I am attempting to output an answer in a spreadsheet that will give me the following:
1A6
I have three separate columns that I have both numbers and/or letters and I need to output the example as above in a 4th column.
OK I am attempting to output an answer in a spreadsheet that will give me the following:
1A6
I have three separate columns that I have both numbers and/or letters and I need to output the example as above in a 4th column.
Assuming your 3 columns are A, B and C and you're picking up the entire cell not just a portion of it, the straight-forward =A1&B1&C1 should do it.
If Column A has the 1 and Column B has the A and Column C has the 6, you would use a function like this:
=CONCAT(A1,B1,C1)
To add more cells, just type a comma in the function and select another cell.