My sheet has 10,000 rows, a lot to work with. For every cell in column D that says DALLAS FT. WORTH I need to populate the the same cell in column K with DALLAS. There are about 70 different cities in column D. I do have a column with all the "convert from" cities with the heading FROM and another column with the "convert to" cities with the heading TO, they just aren't currently reading from/to each other and aren't populating column K.
Thanks in advance.
Thanks in advance.