I tried to search for this solution, but wasn't able to find it and I'm not even sure if I'm asking this the right way.
I have a spreadsheet with an Employee ID column (Column B) and an Email address column (Column C). Not all users have an Employee ID, contractors only have an Email address, so I want to combine columns B and C in to column D. The caveat is column B has blanks, where the user is a contractor, but column C also has blanks. When I use this formula to combine them it works, except in the cases where there is an EID in column B and EMail in column C, it throws a "False" in the column D cell. =IF(C2="",TEXT(B2,"000000000"),IF(B2="",C2)). I have to format column B to provide the leading zeroes for the EID.
Here's a sample of what I'm looking at.
ExcelHelp.png
Any help will be greatly appreciated!
Bookmarks