concatenate two columns

R

ranjan.khan

I would like to concatenate the text in Column B with the text in
Column A and place the results in Column K. Keep in mind that Column
B and Column A may vary in length - meaning that
Column B may have 37 rows of text and and Column A may have 23 rows of
text.
 
D

David McRitchie

Not sure if this is what you wanted, but here is one interpretation:

K23: =TRIM(A23 & " " & B23)

If changes to internal spaces would be inappropriate:

K23: =IF(A23="",IF(B23="","", B23), A23)

TRIM Worksheet Function
Remove duplicate inner spaces as well as the
leading and trailing spaces.

Use the Fill Handle to copy down from first use of formula
http://www.mvps.org/dmcritchie/excel/fillhand.htm
 
D

David McRitchie

correction left out the concatenation in the second example
K23: =IF(A23="",IF(B23="","", B23), A23 & " " & B23)
 
Top