Search for URL and copy URL to new cell

[corzo]

Using Excel 2002.

Search cell for URL, copy URL only, and paste to new cell.

For example:

If A1 contains a URL:
A1 = Hi, my name is corzo http://test.com.

Then copy URL only to new cell:
A2 = http://test.com

Thanks kindly in advance.

 

[hiker95]

corzo,

Welcome to the MrExcel forum.

Based on your example, how about something like this?

Excel 2007
	A	B
1	Hi, my name is corzo http://test.com	http://test.com
2	http://test.com
Sheet1

Cell Formulas
Range	Formula
B1	=MID(A1,FIND("http",A1,1),LEN(A1)-FIND("http",A1,1)+1)
A2	=MID(A1,FIND("http",A1,1),LEN(A1)-FIND("http",A1,1)+1)

 

[corzo]

hiker95, perfect! Thank you very much.

corzo,

Welcome to the MrExcel forum.

Based on your example, how about something like this?

Excel 2007

	A	B
1	Hi, my name is corzo Create Tests for Organizational Training and Certification Programs ? Test.com	http://test.com
2	http://test.com

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =MID(A1,FIND("http",A1,1),LEN(A1)-FIND("http",A1,1)+1) A2 =MID(A1,FIND("http",A1,1),LEN(A1)-FIND("http",A1,1)+1) <tbody> </tbody>

<tbody>
</tbody>

 

[hiker95]

corzo,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.