ExcelBanter - combine two text columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - combine two text columns (https://www.excelbanter.com/excel-discussion-misc-queries/142177-combine-two-text-columns.html)

ferde

combine two text columns

Column A Column B Column C
ADRIAN Adrian
LINA Lina
ARLENE Arlene
TRACY Tracy
ARMIDA Armida
Bob Bob
Joe Joe

I have two columns of names that I would like to combine in column C. There
are blanks where I have indicated.

Is there a formula I can use in column C to accomplish this?
Thank you for your time
Deb

JMB

combine two text columns

See reply in your other post.

"ferde" wrote:

Column A Column B Column C
ADRIAN Adrian
LINA Lina
ARLENE Arlene
TRACY Tracy
ARMIDA Armida
Bob Bob
Joe Joe

I have two columns of names that I would like to combine in column C. There
are blanks where I have indicated.

Is there a formula I can use in column C to accomplish this?
Thank you for your time
Deb

All times are GMT +1. The time now is 04:18 AM.