shrinivasmj
Board Regular
- Joined
- Aug 29, 2012
- Messages
- 140
need formula
Philadelphia Contributionship for the Insurance of Houses from Loss by Fire W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year
were find and put dildimeter like ^ before ^W4Z6QA69
Philadelphia Contributionship for the Insurance of Houses from Loss by Fire ^W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year
in b call data
Philadelphia Contributionship for the Insurance of Houses from Loss by Fire W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year
in c cell =LEFT(B1,LEN(B1)-E1)
in d cell =MID(B1,FIND(" ",B1)+1,LEN(B1))
in e cell=LEN(D1)
in f cell =LEN(C1)
Philadelphia Contributionship for the Insurance of Houses from Loss by Fire W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year
were find and put dildimeter like ^ before ^W4Z6QA69
Philadelphia Contributionship for the Insurance of Houses from Loss by Fire ^W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year
in b call data
Philadelphia Contributionship for the Insurance of Houses from Loss by Fire W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year
in c cell =LEFT(B1,LEN(B1)-E1)
in d cell =MID(B1,FIND(" ",B1)+1,LEN(B1))
in e cell=LEN(D1)
in f cell =LEN(C1)