Excel function to remove/edit strings in a column
Posted on 2011-02-25
In the location column,
I have the following data displayed..
Id like to edit the data in that column to remove the trailing text..Railroad,Trains and Buses
It would be cumbersome to go to its line and manulally remove it. What's excel trick to to do?