Jan 29 2019 10:40 AM
Does anyone have an idea on how to correct the flash fill option? In the column entitled “company name”, I want to combine secondary first and secondary last name. I’m using the flash fill option but as you can see in cell E6, Excel is flash filling Primary last name (which I don’t want). I only want to combine secondary first name and secondary last name. I can’t use formulas to combine the names as the software that I upload the data to doesn’t read any cells with formulas properly. Any help is appreciated!
Jan 29 2019 11:20 AM