Hey Guys. This is what I have.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>[TR]
[TD]United States Steel Corporation (U.S. Steel)[/TD]
[TD]info@uss.com[/TD]
[TD]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?
[/TD]
[/TR]
</tbody>[/TABLE]
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>[TABLE="width: 0"]
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody>[TR]
[TD]United States Steel Corporation (U.S. Steel)[/TD]
[TD]info@uss.com[/TD]
[TD]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?
[/TD]
[/TR]
</tbody>[/TABLE]
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.