Find text and copy into new column (excelvba)
Closed
amzary
-
Oct 19, 2009 at 09:53 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 21, 2009 at 07:01 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 21, 2009 at 07:01 AM
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".
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".
Related:
- Find text and copy into new column (excelvba)
- How to delete column in word - Guide
- Tweetdeck expand column - Guide
- Excel count occurrences of string in column - Guide
- Excel vba find last non empty cell in column - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 21, 2009 at 07:01 AM
Oct 21, 2009 at 07:01 AM
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 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