Hardware | Software | Internet | OS | Communication | Software Development | Safety and Protection | IT Industry | Computer Technology |

Computer Knowledge Home -> Software-> Office software >> word find and replace problem

word find and replace problem

Users questions:Question 1 There are many lines, each line is a proverb, and now want to find the first n characters to a character that contains between m-idioms such as a, to find the first three words are "eye," the word of the idiom. 2, to find the first 2 to 3 between the word containing the words "eye," the word idiom. Ercongmuming ears clean ears red Mianchi ear epigenetic WindGu Gong eyes and ears of fresh eyes and ears of the notorious soft heart live monasteries ear ear ear as the head about eating well known imparting instruction to listen to heart by the ears hear better than for oneself heard and saw the problem for oneself heard two witnesses heard a lot of lines, the line starts with some statistics, but they Some are right at the beginning of digital characters, and some spaces, commas,Comma. These figures should now start up the right until the spaces between characters, comma, comma are replaced by only two spaces. For example, take the following quite a resentment of Health 2-en-en with their parents, Mathias 3 Entongzaizao four parallel 5, cop 6, TU has restated 7, 8-en more than a loving mother, Enyuanfenming 333, en re -En 4444, such as heavy Taishan Mountain 55, children two girls love long thirties replace a substantial resentment of Health 2-en-en with their parents, Mathias 3 Entongzaizao four parallel 5 cop 6-en-en more than a restatement 7 Mother 8 Enyuanfenming 4444 TU 333 Enzhongrushan re Tarzan 55 children, 2 women love long thirties 2nd Floor wecansam said, "plus an auxiliary column, use the formula = FIND (" head ", A1) = 3)," auxiliary column, the formula written in where?
Experts answer: The first problem can add an auxiliary column, find the first three words are "eye," the word used in the formula = FIND ( "head", A1) = 3), if the resultIs true is looking for. Finding what you want to find the first 2 to 3 between the word containing the words "eye," the word phrase use the formula = OR (FIND ( "head", A1) = 2, FIND ( "head", A1) = 3), the result is ture is looking for. Remaining issues will continue to work
  • This information provided by the users.Thanks!
Trade Company Database Computer Question United States Company Directorys MotorbikesTip
Computer Knowledge Copyright 2005-2015 All Rights Reserved.