Trim or RegEx: How to remove string after special character

[JoshuaBova]

I have a list of addresses that need to have the Suite numbers removed. See Below

What I have	What I need
Address	Address
5077 SABRE LN # A	5077 SABRE LN
3210 FALLMEADOW ST # 127A	3210 FALLMEADOW ST
721 S INTERSTATE 35 E # 144	721 S INTERSTATE 35 E

What is the best way to do this? Thanks!

[Usamah22]

Thanks, text to columns was straightforward.

[AnunavamikkaVelusamy]

What if I needed,

Thanks!