Help me to count different charecters on 2 cells

[Closed]
Report
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
Hello,

Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa is in A2, it shoud be 2.. and also want to multiply the result by 2. so output should be A3=4..