Appendix Thread. App Index Rws() Clms() Majic code line Codings for other Threads, Tables etc.)

[DocAElstein]

In support of this main Forum Thread
https://excelfox.com/forum/showthrea...earched-string

Input

					
"#VBA: keep only one searched string searched string searched string searched string.
#VBA: keep only searched string one searched string.
The list of search stings searchedCSV string searched string is given in sheet 2.
In sheet1, with #VBA check if a given string is CSV searched string found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with CSV searched string multiple column data in multiple rows as well as in a CSV or text file."				
				
"searched string searched string #VBA: keep only one searched string.
#VBA: keep only one searched string.
searched string searched string searched stringThe list of search stings is given in sheet 2.
In sheet1, with #VBA check if a given string is found more than once #VBA #VBA #VBA #VBA #VBA #VBA #VBA #VBA #VBA #VBA #VBA #VBA in a paragraph/line. If found more than once then keep only one. #VBA #VBA #VBA #VBA 
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."				
				
"#VBA: keep only one searched string.
#VBA: keep only one searched string.
The list of search stings is given in sheet 2.
In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file. #VBA: keep only one searched string.
#VBA: keep only one searched string. searched string searched string searched string searched string
The list of search stings is given in sheet 2. searched string searched string searched string searched string
In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."				
				
				
				
				
	"#VBA: #VBA  keep only one searched string.
#VBA: #VBA #VBAkeep only one searched string.
              searched string searched string  searched string  searched string  searched string
In sheet1, with #VBA check if a given string is found more than #VBA once in a paragraph/line. If found more than #VBA once then keep only one.

#VBA: keep only one searched string.
The list of search stings is given in sheet 2.
In sheet1, with #VBA check if a given string is found more than #VBA once in a paragraph/line. If found more than #VBA once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."			
				
				
				"#VBA: keep only one searched string.


In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file. #VBA: keep only one searched string.


In sheet1, with #VBA check if a  paragraph/line given string is found more than once in a paragraph/line paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."

Output

				
"#VBA: keep only one searched string .
#VBA: keep only searched string one .
The list of search stings searchedCSV string searched string is given in sheet 2.
In sheet1, with #VBA check if a given string is CSV searched string found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with CSV searched string multiple column data in multiple rows as well as in a CSV or text file."				
				
"searched string  #VBA: keep only one searched string.
#VBA: keep only one searched string.
searched string searched stringThe list of search stings is given in sheet 2.
In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one. 
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."				
				
"#VBA: keep only one searched string.
#VBA: keep only one searched string.
The list of search stings is given in sheet 2.
In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file. #VBA: keep only one searched string.
#VBA: keep only one searched string.  
The list of search stings is given in sheet 2. searched string
In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."				
				
				
				
				
	"#VBA:   keep only one searched string.
#VBA: keep only one searched string.
              searched string
In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.

#VBA: keep only one searched string.
The list of search stings is given in sheet 2.
In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."			
				
				
				"#VBA: keep only one searched string.


In sheet1, with #VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file. #VBA: keep only one searched string.


In sheet1, with #VBA check if a  paragraph/line given string is found more than once in a paragraph/line paragraph/line. If found more than once then keep only one.
I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file."

[DocAElstein]

Output required ( https://excelfox.com/forum/showthrea...ll=1#post16685 )

_____ Workbook: VBA row to cell1.xlsx ( Using Excel 2007 32 bit )

Row\Col	A
2	234. digital marketing information: 2021-2022***….Keywrod1: 2021-2022*** Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Keywrod1: Keyword2: 30000000 *&^%$QWERTY QWERTY
3	2344. digital marketing information: 2020-2021***….Keywrod1: *** 2020-2021 digital marketing information digital marketing information Digital marketing: = also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel." "Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel." Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel." Keywrod1: *** 2020-2021 Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Keyword2
4	1. digital marketing information: 2021-2022***….Keywrod1: 2021-2022*** Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. Digital marketing, also called online marketing, is the promotion of brands to connect with potential customers using the internet and other forms of digital communication. This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel. QWERTY Keyword2: 30000000 *&^%$QWERTY QWERTY

Worksheet: OutputSheet2

"234. digital marketing information: 2021-2022***….Keywrod1: 
2021-2022***

Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.


Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.

Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.

Keywrod1: 
Keyword2: 30000000 *&^%$QWERTY QWERTY"
"2344. digital marketing information: 2020-2021***….Keywrod1: *** 2020-2021
digital marketing information
digital marketing information

Digital marketing: =
also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.""
""Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.


Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.

Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.""

Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.

Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.""
Keywrod1: *** 2020-2021
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Keyword2"
"1. digital marketing information: 2021-2022***….Keywrod1: 
2021-2022***

Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.
Digital marketing, also called online marketing, is the promotion of brands to 
connect with potential customers using the internet and other forms of digital communication. 
This includes not only email, social media, and web-based advertising, but also 
text and multimedia messages as a marketing channel.


QWERTY Keyword2: 30000000 *&^%$QWERTY QWERTY"