 |
Can I combine a city and state from two cells, into one cell in a formula? Yes. Here is a scenario. There are 4 columns that are set up as follows: origin city, origen state, destination city, destination state. The fifth column, you want the miles for the route from the first 4 columns. Here is the formula you need to enter: =miles(a1&","&b1, c1&","&d1) | |||
|
||||
VIEW CART