Hello All
I have a spreadsheet containing name of suppliers (lawyers) and the full address of their law chambers. I am trying to extract only the name of the chambers from the full address. The name will then populate under "Name of Chamber" column.
I am stumped as to how to go about doing...