Copy and Paste Specific Range of Words

[Vgabond]

Hi Gurus


Need your assistance on the above where I wish to copy and paste specific range of words in a cell. The wording will be in Column I. The words that need to find, copy and paste will be "Others" and follow with the 60 continuous character after that. It will actually a wording after “Others” that I am looking for. Thus it should be paste to the next column.

Any help is appreciated

 

[Dermot]

This should work - column B finds the word Other, and column C copies the text you need

Book2
	A	B	C	D
1	Others AAA,BBB,CCC	1	AAA,BBB,CCC
2	DDD	0
3	EEE	0
4	FFF, Others GGG, HHH	6	GGG, HHH
Sheet1

Cell Formulas
Range	Formula
B1:B4	B1	=IFERROR(FIND("Others",A1),0)
C1:C4	C1	=IF(B1=0,"",MID(A1,B1+6,60))

 

[Vgabond]

Th

This should work - column B finds the word Other, and column C copies the text you need

Book2
	A	B	C	D
1	Others AAA,BBB,CCC	1	AAA,BBB,CCC
2	DDD	0
3	EEE	0
4	FFF, Others GGG, HHH	6	GGG, HHH
Sheet1

Cell Formulas
Range	Formula
B1:B4	B1	=IFERROR(FIND("Others",A1),0)
C1:C4	C1	=IF(B1=0,"",MID(A1,B1+6,60))

Hey there

Let me try and revert

 

[Vgabond]

Thank you very much. It works like a charms !!!!! Thanks again