DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,968
I could use some assistance this morning please.
I need to locate and extract the first letter of the second word and add it to an existing formula.
The following is the existing formula. I need to add column "I" a second time, immediately following the first occurrence of "I" but it needs to extract the first letter of the second word which is proceded by a space.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F146&LEFT(I146,1)&(LEFT(P146,1)&LEFT(J146,1)&LEFT(M146,2)&LEFT(K146,1)&LEFT(R146,1)&LEFT(O146,1)&LEFT(N146,2)&LEFT(Q146,2)&RIGHT(U146,2)),".",""),"/","")," ","")
Example:
Existing Text Phrase:
CAMO FORREST
Extract the "F"
Thanks,
Doug
I need to locate and extract the first letter of the second word and add it to an existing formula.
The following is the existing formula. I need to add column "I" a second time, immediately following the first occurrence of "I" but it needs to extract the first letter of the second word which is proceded by a space.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F146&LEFT(I146,1)&(LEFT(P146,1)&LEFT(J146,1)&LEFT(M146,2)&LEFT(K146,1)&LEFT(R146,1)&LEFT(O146,1)&LEFT(N146,2)&LEFT(Q146,2)&RIGHT(U146,2)),".",""),"/","")," ","")
Example:
Existing Text Phrase:
CAMO FORREST
Extract the "F"
Thanks,
Doug