rafi_07max
01-16-2011, 07:44 PM
Extract a specific word into the spreadsheet\
Once opened the file,
Look for the word “execute”
1. If the word “execute’ is the first word of the line, then extract the next word after the word :”execute” and place in column A Take a look at the image below
http://www.iimmgg.com/image/46b40b45f57f4f299b1c49d332eb0bf1
2. If the word “execute’ is not the first word of the line, then extract the next word after the word :”execute” and place in column B Take a look at the image below
http://www.iimmgg.com/image/1499df067db18205e922a20ea17a8671
I have attached a sample workbook
Sheet 1 shows how my sheet looks like once extracted
Sheet 2 contains a button where the codes should be inserted
I have also attached a sample .txt file that I need to extract
5243
Once opened the file,
Look for the word “execute”
1. If the word “execute’ is the first word of the line, then extract the next word after the word :”execute” and place in column A Take a look at the image below
http://www.iimmgg.com/image/46b40b45f57f4f299b1c49d332eb0bf1
2. If the word “execute’ is not the first word of the line, then extract the next word after the word :”execute” and place in column B Take a look at the image below
http://www.iimmgg.com/image/1499df067db18205e922a20ea17a8671
I have attached a sample workbook
Sheet 1 shows how my sheet looks like once extracted
Sheet 2 contains a button where the codes should be inserted
I have also attached a sample .txt file that I need to extract
5243