Brian12q34
New Member
- Joined
- Oct 14, 2016
- Messages
- 9
I have a spreadsheet that has 7 columns of URLs and i need to place a double hash tag between each URL row a is my mpn row b is my image name row c is the first set of URLs row d is for the (2) ## hash tags row e is my second set of URLs row f is for 2 hashtags row g is my third set of URLs row H is 2 Hashtags Row I is my 4th set of URLs row J is for 2 hash tags row k is my 5th set of URLs Row L is for 2 hash tags row m is two hash tags row n is my last set of URLs. I am looking for a command to tell excel that if their is a URL in the Row to the right to place 2 hash tags next to it . see example i have 115607 rows. Thank you Howard
[TABLE="width: 3951"]
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Item #[/TD]
[TD]Image name[/TD]
[TD]URL to large image[/TD]
[TD]##[/TD]
[TD]Extra Img 1[/TD]
[TD]##[/TD]
[TD]Extra Img 2[/TD]
[TD]##[/TD]
[TD]Extra Img 3[/TD]
[TD]##[/TD]
[TD]Extra Img 4[/TD]
[TD]##[/TD]
[TD]Extra Img 5[/TD]
[TD]##[/TD]
[TD]Extra Img 6[/TD]
[/TR]
[TR]
[TD="align: right"]2758[/TD]
[TD]2758.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/2758.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007992.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007993.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007994.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007995.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007996.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007997.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]5349[/TD]
[TD]5349.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/5349.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5349_25904230.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5349_25904231.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5659[/TD]
[TD]5659.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/5659.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5659_25696155.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6652[/TD]
[TD]6652.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/6652.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6679[/TD]
[TD]6679.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/6679.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339424.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339425.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339426.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339427.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7104[/TD]
[TD]7104.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7104.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711439.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711440.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711441.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711442.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711443.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711444.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]7105[/TD]
[TD]7105.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7105.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602039.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602040.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602041.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769868.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769869.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769870.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]7157[/TD]
[TD]7157.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7157.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715963.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715964.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715965.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7340[/TD]
[TD]7340.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7340.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712591.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712592.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712593.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712594.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712595.jpg[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 3951"]
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Item #[/TD]
[TD]Image name[/TD]
[TD]URL to large image[/TD]
[TD]##[/TD]
[TD]Extra Img 1[/TD]
[TD]##[/TD]
[TD]Extra Img 2[/TD]
[TD]##[/TD]
[TD]Extra Img 3[/TD]
[TD]##[/TD]
[TD]Extra Img 4[/TD]
[TD]##[/TD]
[TD]Extra Img 5[/TD]
[TD]##[/TD]
[TD]Extra Img 6[/TD]
[/TR]
[TR]
[TD="align: right"]2758[/TD]
[TD]2758.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/2758.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007992.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007993.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007994.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007995.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007996.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007997.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]5349[/TD]
[TD]5349.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/5349.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5349_25904230.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5349_25904231.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5659[/TD]
[TD]5659.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/5659.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5659_25696155.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6652[/TD]
[TD]6652.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/6652.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6679[/TD]
[TD]6679.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/6679.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339424.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339425.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339426.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339427.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7104[/TD]
[TD]7104.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7104.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711439.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711440.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711441.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711442.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711443.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711444.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]7105[/TD]
[TD]7105.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7105.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602039.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602040.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602041.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769868.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769869.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769870.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]7157[/TD]
[TD]7157.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7157.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715963.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715964.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715965.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7340[/TD]
[TD]7340.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7340.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712591.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712592.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712593.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712594.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712595.jpg[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]