Remove Numbers/Character From Column

[Toki]

Hello all,

Not sure if this can be done or not but in A1 I have, for example:

11:23:17,http://www.website.com

The numbers vary but always in that form.

I am trying to eliminate the numbers and the comma, so all I have left in column A1 is the url's.

Can this be done?

Thanks!

I am on a mac using microsoft excel 2011

 

[Warship]

With your string in "A1" try:

=MID(A1,FIND("http",A1),LEN(A1)-FIND("http",A1)+1)

 

[Haseeb Avarakkan]

Or,

=REPLACE(A1,1,SEARCH("http",A1)-1,"")

 

[scottylad2]

this will get you the URL, you can lose the Hyperlink part of the function if you only need a readable URL like so

Excel Workbook
	C	D
3	11:alphadot,http://www.website.com	http://www.website.com
4	11:23:17,http://www.otherwebsite.com	http://www.otherwebsite.com
Sheet1

but if you need to be left with clickable hyperlinks use this

Excel Workbook
	C	D
2
3	11:alphadot,http://www.website.com	http://www.website.com
4	11:23:17,http://www.otherwebsite.com	http://www.otherwebsite.com
Sheet1

 

[Toki]

Great, that did the trick! I appreciate it. I do have another question

Now that those numbers are gone... whats left in my A1 column is:

http://www.website.com,http://www.website.com

Is there a way to grab that comma and the second url and place it in another column, say B1?

Thanks guys!

 

[Scott Huish]

How did you end up with that in A1, it wasn't in your original sample.

The formulas given should go in Column B to begin with:

Excel Workbook
	A	B
1	11:23:17,http://www.website.com	http://www.website.com
2
Sheet1