| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add text to begining of cells within a range based on specified criteria
I need to select the contents of a cell based on the contents of
another cell and then I need to add that text to the begining of other cells until I reach the destination cell. below is an example of what i am trying to do: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I need to find cells with "STANDARDS FOR FOREIGN LANGUAGE LEARNING" i then need to extract the contents of the cell below it "Vocabulario en acción 1" i need to delete this row and then paste this at the begining of all the cells below until i reach "CORE INSTRUCTION" below is the end result: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 - Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Vocabulario en acción 1 - Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Vocabulario en acción 1 - Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Vocabulario en acción 1 - Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Vocabulario en acción 1 - Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I have 7000-8000 rows if info similar to this but it varies in the middle. i would love to be able to have a box ask me for the text to look for i.e. "STANDARDS FOR FOREIGN LANGUAGE LEARNING" and then a box asking me for the text to end "CORE INSTRUCTION" If anyone can help with this i would really appreciate it God bless jsd219 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add text to begining of cells within a range based on specifiedcriteria
You have a response at your other post.
jsd219 wrote: I need to select the contents of a cell based on the contents of another cell and then I need to add that text to the begining of other cells until I reach the destination cell. below is an example of what i am trying to do: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I need to find cells with "STANDARDS FOR FOREIGN LANGUAGE LEARNING" i then need to extract the contents of the cell below it "Vocabulario en acción 1" i need to delete this row and then paste this at the begining of all the cells below until i reach "CORE INSTRUCTION" below is the end result: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 - Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Vocabulario en acción 1 - Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Vocabulario en acción 1 - Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Vocabulario en acción 1 - Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Vocabulario en acción 1 - Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I have 7000-8000 rows if info similar to this but it varies in the middle. i would love to be able to have a box ask me for the text to look for i.e. "STANDARDS FOR FOREIGN LANGUAGE LEARNING" and then a box asking me for the text to end "CORE INSTRUCTION" If anyone can help with this i would really appreciate it God bless jsd219 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add text to begining of cells within a range based on specified criteria
Are you refering to the question asked by Pete? or is there another
response that i did not see? God bless jsd219 Dave Peterson wrote: You have a response at your other post. jsd219 wrote: I need to select the contents of a cell based on the contents of another cell and then I need to add that text to the begining of other cells until I reach the destination cell. below is an example of what i am trying to do: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I need to find cells with "STANDARDS FOR FOREIGN LANGUAGE LEARNING" i then need to extract the contents of the cell below it "Vocabulario en acción 1" i need to delete this row and then paste this at the begining of all the cells below until i reach "CORE INSTRUCTION" below is the end result: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 - Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Vocabulario en acción 1 - Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Vocabulario en acción 1 - Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Vocabulario en acción 1 - Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Vocabulario en acción 1 - Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I have 7000-8000 rows if info similar to this but it varies in the middle. i would love to be able to have a box ask me for the text to look for i.e. "STANDARDS FOR FOREIGN LANGUAGE LEARNING" and then a box asking me for the text to end "CORE INSTRUCTION" If anyone can help with this i would really appreciate it God bless jsd219 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add text to begining of cells within a range based on specifiedcriteria
Since you posted to multiple newsgroups, you'll have to check each of those
newsgroups for responses. That's one of the problems with doing this--it makes more work for you. The other problem is that if you already have an answer in a different newsgroup, it wastes the time of anyone answering in this newsgroup. jsd219 wrote: Are you refering to the question asked by Pete? or is there another response that i did not see? God bless jsd219 Dave Peterson wrote: You have a response at your other post. jsd219 wrote: I need to select the contents of a cell based on the contents of another cell and then I need to add that text to the begining of other cells until I reach the destination cell. below is an example of what i am trying to do: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I need to find cells with "STANDARDS FOR FOREIGN LANGUAGE LEARNING" i then need to extract the contents of the cell below it "Vocabulario en acción 1" i need to delete this row and then paste this at the begining of all the cells below until i reach "CORE INSTRUCTION" below is the end result: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 - Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Vocabulario en acción 1 - Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Vocabulario en acción 1 - Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Vocabulario en acción 1 - Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Vocabulario en acción 1 - Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I have 7000-8000 rows if info similar to this but it varies in the middle. i would love to be able to have a box ask me for the text to look for i.e. "STANDARDS FOR FOREIGN LANGUAGE LEARNING" and then a box asking me for the text to end "CORE INSTRUCTION" If anyone can help with this i would really appreciate it God bless jsd219 -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add text to begining of cells within a range based on specified criteria
I posted in four newsgroups and have been monitoring all four. i do not
see a response other than Pete asking why i am not doing this in word. is there another response that i have overlooked? please let me know i am desperate. God bless jsd219 Dave Peterson wrote: Since you posted to multiple newsgroups, you'll have to check each of those newsgroups for responses. That's one of the problems with doing this--it makes more work for you. The other problem is that if you already have an answer in a different newsgroup, it wastes the time of anyone answering in this newsgroup. jsd219 wrote: Are you refering to the question asked by Pete? or is there another response that i did not see? God bless jsd219 Dave Peterson wrote: You have a response at your other post. jsd219 wrote: I need to select the contents of a cell based on the contents of another cell and then I need to add that text to the begining of other cells until I reach the destination cell. below is an example of what i am trying to do: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I need to find cells with "STANDARDS FOR FOREIGN LANGUAGE LEARNING" i then need to extract the contents of the cell below it "Vocabulario en acción 1" i need to delete this row and then paste this at the begining of all the cells below until i reach "CORE INSTRUCTION" below is the end result: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 - Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Vocabulario en acción 1 - Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Vocabulario en acción 1 - Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Vocabulario en acción 1 - Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Vocabulario en acción 1 - Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I have 7000-8000 rows if info similar to this but it varies in the middle. i would love to be able to have a box ask me for the text to look for i.e. "STANDARDS FOR FOREIGN LANGUAGE LEARNING" and then a box asking me for the text to end "CORE INSTRUCTION" If anyone can help with this i would really appreciate it God bless jsd219 -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add text to begining of cells within a range based on specifiedcriteria
That's the one I saw, but since you multiposted, you'll have to continue to
monitor all responses. jsd219 wrote: I posted in four newsgroups and have been monitoring all four. i do not see a response other than Pete asking why i am not doing this in word. is there another response that i have overlooked? please let me know i am desperate. God bless jsd219 Dave Peterson wrote: Since you posted to multiple newsgroups, you'll have to check each of those newsgroups for responses. That's one of the problems with doing this--it makes more work for you. The other problem is that if you already have an answer in a different newsgroup, it wastes the time of anyone answering in this newsgroup. jsd219 wrote: Are you refering to the question asked by Pete? or is there another response that i did not see? God bless jsd219 Dave Peterson wrote: You have a response at your other post. jsd219 wrote: I need to select the contents of a cell based on the contents of another cell and then I need to add that text to the begining of other cells until I reach the destination cell. below is an example of what i am trying to do: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I need to find cells with "STANDARDS FOR FOREIGN LANGUAGE LEARNING" i then need to extract the contents of the cell below it "Vocabulario en acción 1" i need to delete this row and then paste this at the begining of all the cells below until i reach "CORE INSTRUCTION" below is the end result: STANDARDS FOR FOREIGN LANGUAGE LEARNING Vocabulario en acción 1 - Communication 1.1 Students engage in conversations, provide and obtain information, express feelings and emotions, and exchange opinions Vocabulario en acción 1 - Communication 1.2 Students understand and interpret written and spoken language on a variety of topics Vocabulario en acción 1 - Communication 1.3 Students present information, concepts, and ideas to an audience of listeners or readers on a variety of topics Vocabulario en acción 1 - Cultures 2.1 Students demonstrate an understanding of the relationship between the practices and perspectives of the culture studied Vocabulario en acción 1 - Comparisons 4.2 Students demonstrate understanding of the concept of culture through comparisons of the cultures studied and their own CORE INSTRUCTION I have 7000-8000 rows if info similar to this but it varies in the middle. i would love to be able to have a box ask me for the text to look for i.e. "STANDARDS FOR FOREIGN LANGUAGE LEARNING" and then a box asking me for the text to end "CORE INSTRUCTION" If anyone can help with this i would really appreciate it God bless jsd219 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color a range of cells based on a criteria | Excel Discussion (Misc queries) | |||
| VLOOKUP based on PART of another cell's text | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Linear Mode
