Hey Guys. This is what I have.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>
</tbody><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>
</tbody>
I want to take ALL of the word from A and insert into C between "at" & "."
I have several hundred rows. So I want to be able to insert a formula and fill down.
Do I use "LEFT", "REPLACE", or what?
Thanks a bunch.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
A | B | C |
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>
</tbody>
United States Steel Corporation (U.S. Steel) | info@uss.com | Hi, I’m trying to figure out who oversees freight and shipping there at U.S. Steel. Would you mind pointing me towards the right person please, and the best way I might get in touch with them? |
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>
</tbody>
I want to take ALL of the word from A and insert into C between "at" & "."
I have several hundred rows. So I want to be able to insert a formula and fill down.
Do I use "LEFT", "REPLACE", or what?
Thanks a bunch.