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.

In C1 enter:
=A1 & B1

and copy down as far as you like.
--
Gary''s Student
gsnu200710


"(E-Mail Removed)" wrote:

> 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.
>
>

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

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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 Column A may have 23 rows of
> text.
>

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


"David McRitchie" <(E-Mail Removed)> wrote in message news:%23DK$(E-Mail Removed)...
> 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:
>
> [see correction]