Remove First Digits From Column?

[Toki]

Hello,

In my column A I have this:

1 http://websitename.com/whatever here
19 http://websitename.com/whatever here

I was wondering how I could remove the digits (the numbers go from 1-300) so all I left is the website url.

Thanks

 

[Scott R]

=MID(A1,FIND("http:",A1),LEN(A1))

 

[texasalynn]

use the text-to-column with delimiter of space, then you can delete the column with the numbers

 

[Toki]

Scott R - That worked great.

texasalynn - For my own info, how would I "use the text-to-column with delimiter of space"?

 

[Toki]

Nevermind texasalynn I got it! That worked even better!

 

[texasalynn]

That's great and thank you for the feedback