Need help merging 2 columns

[spongmonger]

I have a column of names with every cell of the column filled, then next to it I have a column of sporadically populated cells containing nicknames for those in column 1. I need to replace the names in the first column with the nicknames in the second column, but leave the names for which there is no nickname unchanged. How can I do this?

[63falcondude]

Try using a formula like this in a 3rd column:

C2 =IF(B2="",A2,B2)

Drag the formula down column C.

[spongmonger]

Thank you, that was it!

[63falcondude]

You’re welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.