Mar 04 2019 01:25 PM
I have an excel file of contact names. The first name is in one cell (Cell A) and the last name is in a separate cell (Cell B). They are in the same row. I have over 1600 contact names (or rows) like this. I want the first and last names to be merged with one another in just one cell. How do I do this in the quickest and simplest way?
Mar 04 2019 01:49 PM
If you are on Excel 2013 or later Flash Fill could be the easiest https://support.office.com/en-us/article/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f7...
Jul 01 2019 12:47 PM
@kasimley In C1 enter: A1&" "&B1