I have a challenge in MS-Excel 2010.

I have two columns that I need to merge and data in each cell overwritten conditionally (plz. see attached sample spreadsheet).

I am working on a key engagement and need to solve this ASAP, and greatly appreciate any help.

I believe my querry is pretty simple and can be solved by somebody and may take just a couple of mins. for someone here to suggest how to solve it.



Thanks a ton!

Attached Files

TEMP4-Last Names MERGE COLUMNS Test 2012-10-24.xlsx (84.7 KB, 9 views)

Hi and welcome

Perhaps sthg like in F2?

Pull down as needed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks, will try.

=IF(E3="-",B3&"",E3&"")

Thanks again! Saved me a ton of manual entry!