Hello:
I need some assistance with updating the *case* (lower/upper) of a word's **first** letter.
Background:
- As part of standardizing job description's tenses, I have a VBA routine which updates a word in past tense from (e.g., "Acquired") to simple present tense (e.g., "Acquire").
- This routine works fine; however, depending on previous word usages, a word's **first** letter may erroneously get changed from, e.g., "a" to "A" or vice versa.
- Attached XLS contains a few sample words in column B. These words may be written in past tense, simple present tense, or simple present tense continuous. All of these are fine.
- The issue lies in column C. Although the tenses are correct for all words, the 1st letter of the word in column C may be different than the 1st letter of column B (regardless of the tense).
My goal:
- I need to come up with an Excel formula with will "look" at the case of the 1st letter in column C and then compare it to the 1st letter of the word in column B.
- If there is a difference (whether it's upper vs. lower OR lower vs. upper), then the 1st letter of the word in column C must be updated to the 1st letter of column B's word (while keeping column C's word in the same tense... i.e., simple present tense).
Again, as a picture is worth a 1000s words, a look at the attached XLS should make the requirement clear. Does anyone know which formula (e.g., in column F) would update column C's 1st letter correctly?
Thanks,
EEH
Bookmarks