New Problem with large data base

[pick44]

My addresses ( not all) have apt#'s after the address number, like this. 11300-11499 RENDEZVOUS

The address is 11300 RENDEZVOUS. My addresses are in column F2 thru F61613. Can you help> Thanks

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[Sam Capricci]

Could you please change your post title to something appropriate to your issues per forum rule #1?
And what exactly is your issue? A sample workbook with a small sample AND expected results could go a long way to getting an answer.
Help us to help you.

[pick44]

Sorry about Title. Will do better next time.

I figured it out. I will update my profile also. Thanks

[Sam Capricci]

Glad you figured it out, if you wish to share your solution, others with a similar problem might benefit from it.