How do I check the following:
1) in column B (beginning in Row 5, hence B5 to last row in column B), I have several data.
2) They begin with markups, e.g. _rfsti, _par1, _adseq, _rftxt, _rfeti followed by a blank space followed by a sentence (or numerical values)
Sample is shown below:
_adseq 1
_rfsti This is a sentence
_rftxt United States
_rfeti This is another sentence
3) check if the data begins with the markup "_rfsti" or "_rfeti", if it finds a match, do the following:
check if the first letter of the value is in lower case, if it is in lower case returns the value "First letter should be capitalized" in column C in the same row where it finds the match
if the first letter of the value is in upper case, returns blank
4) check if the data begins with the markup "_rftxt", if it finds a match, do the following:
check if ALL the cases of the value are in proper case, if it is NOT in proper case returns the value "Words should be in proper case" in column C in the same row where it finds the match
if the first letter of the value is already in proper case, returns blank value
Kindly guide me how to get this started.
1) in column B (beginning in Row 5, hence B5 to last row in column B), I have several data.
2) They begin with markups, e.g. _rfsti, _par1, _adseq, _rftxt, _rfeti followed by a blank space followed by a sentence (or numerical values)
Sample is shown below:
_adseq 1
_rfsti This is a sentence
_rftxt United States
_rfeti This is another sentence
3) check if the data begins with the markup "_rfsti" or "_rfeti", if it finds a match, do the following:
check if the first letter of the value is in lower case, if it is in lower case returns the value "First letter should be capitalized" in column C in the same row where it finds the match
if the first letter of the value is in upper case, returns blank
4) check if the data begins with the markup "_rftxt", if it finds a match, do the following:
check if ALL the cases of the value are in proper case, if it is NOT in proper case returns the value "Words should be in proper case" in column C in the same row where it finds the match
if the first letter of the value is already in proper case, returns blank value
Kindly guide me how to get this started.