Search : in
By :

Find text and copy into new column (excelvba)

Last answer on Oct 21, 2009 12:01:48 pm BST amzary, on Oct 20, 2009 2:53:06 am BST 
 Report this message to moderators

Hello,
Please help me, can anyone of you tell me how to find a text in excel for example "channel1" then find "channel2" and then "channel3".all the text are written in the same column "column A". then cut and paste all the other text in range between text "channel2" and "channel3" into a new column "column B".

Configuration: Windows XP Internet Explorer 6.0

Best answers for « find text and copy into new column (excelvba) » in :
[MySQL]Loading a text file into ue table Show[MySQL]Loading a text file into ue table To load a text file as follows: $ tail /home/user1/test.txt 'name1',1,9 'name2',2,3 'name3',3,54 'name4',4,2 'name5',5,9 In a table defined as follows: CREATE TABLE...
Inserting text in a file ShowInserting text in a file Introduction Syntax Introduction It is sometimes useful to insert text in the header of one or more document (s) or in a specific part of the document (before or after a specific line). The publisher of...
Copy/Paste problems when using Firefox ShowCopy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...
Download Join (Merge) Text Files Software ShowDescription The application is designed by Sobolsoft. Simple and easy to use, the application has been awarded from various places. Join Text Files a tool that enables you to merge several files. It allows you to merge multiple text files into a...
Download Architecture 3D ShowDescription: With a realism and one made incredible, this software can simulate you what can resemble the home of your dreams. Building and development! These words will find their place in this new grind of software. This version is designed for...
Download TextMaster Split & Join Show
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

2

 Excelguru, on Oct 21, 2009 12:01:48 pm BST

Hello

A suggestion
conditional format with several colours and check manually

or you can put this formula in cell B2
=IF(A2="channel1",1,IF(AND(B1=1,A2="channel2"),2,IF(AND(B1=2,A2="channel3"),3,0)))
and filter for number three to check the occurance of channel 1,2,3 in order A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

   
Reply to Excelguru
Ask your question Reply
They need your help