Merge data from three columns

0

I would like to merge the contents of three columns into a single column. I need to use a nested if formula as the columns take precedence over each other. Example column A1 may or may not have data. If A1 does have data then use A1 data regardless of what is in B1, or C1. If Col A1 is empty use B1 value, if B1 is also empty use C1…. Any ideas?

John Kenny

Posted 2016-04-28T13:02:35.930

Reputation: 1

Answers

0

=IF(A1<>"",A1,IF(B1<>"",B1,C1))

Máté Juhász

Posted 2016-04-28T13:02:35.930

Reputation: 16 807

Thanks... The paren placement always confounds me with Excel. This formula worked like a charm. – John Kenny – 2016-04-28T15:05:47.153

@JohnKenny Please finish the paperwork and mark the answer, then. That's how to say Thank you here. Read What should I do when someone answers my question

– teylyn – 2016-04-28T20:57:18.507

Asked: 2016-04-28T13:02:35.930

Viewed: 55 times

Active: 2016-04-28T13:06:02.073