Excel-text result of 2 text columns

Question

I have 2 columns (A & B) with text. Column A has a variety of text values and blanks. Column B always has matching text values to those values in column A, except for some blank values in column A will have a new value in column B. Ex:

Column A

blue
blank
red
blank

column B

blue
blank
red
yellow

I would want column C to display (in order)

blue
blank
red
yellow

Can a formula be created for this?

So since they match just return column B? there is no difference between C and B. — Scott Craner, Jun 15 '18 at 19:01
Oops sorry, sometimes there are blanks in column B, so I would need to take the values for those rows from column A — E.Weave., Jun 15 '18 at 19:11
ah so if both blank then blank otherwise which ever is not blank? — Scott Craner, Jun 15 '18 at 19:12
https://stackoverflow.com/questions/20103881/is-there-a-coalesce-like-function-in-excel — Julia Leder, Jun 15 '18 at 19:12

Scott Craner · Accepted Answer · 2018-06-15T19:21:12.557

0

a simple IF with AND:

=IF(AND(A1<>"",B1<>""),A1,A1&B1)

edited Jun 15 '18 at 19:21

answered Jun 15 '18 at 19:14

Scott Craner

148,073
10
49
81

Excel-text result of 2 text columns

1 Answers1