MS Excel is very powerful for processing worksheets and any data that can be organized in a tabular form. However built-in function are not available for some sort of problems. For example I can share a practical scenario for which one of my friends asked me a solution.
He has a file which contains multiple data records exported from some accounting software. Each record contains an amount as the last word of the line. Like follows
Electricity Charge 3000
News Papers and Periodicals 2000
Food Expenses 1000
Miscellaneous 2500
etc.
His requirement is quite simple. He want to calculate the total of these expenses. He copied this text to a Excel wok sheet. In Excel work sheet one line of text will be considered as the content of one cell. Like this
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAbAAAAD+CAIAAADUCcfVAAAgAElEQVR4nO2de1hb553nNW2fZrLNbGdnNjvPdJ7d6e4zU2a229btTGnmQkro7tRPZ7ZLL6m9mWZLJmnjuK1NSXBI4iTk7tjGJo4xtmUDtpENvoqLMYibuAoQuiAkJHQ9ugCS0F2AJCSh/UMgpFfnSAJLRxzx+zzfP9DhXL7n8vvynnPQ+9LkpiAJUpqDclNQaw3obcGckc4ayIQwS0C1GFCYAuScGhAIFBFNMreaaWkW/UaH3+b229x+tyew7A2s+HJBS96MyLEcMDv9eptfaVqVzvtmMn+CQCBQWDTpvC/TEhuWpjXOIYmZNWno4mpZXB1rEkSofuEcb9Yyb/VYXKsG26rC6JPOe0k4TSAQiDa74CNBM4YVsW5pWrfUOaHjzJjUC0sgIsn0Tu7sYue4tpun11lW5u2rarNPbiTjNIFAu1xbC8QhIVZ/s+vDM4w3T9S/VdX49ummyuqmt09fr6y68uGZRvr19u7RGYluSTbvxVvcqzb7VCZvn2B+cHrBYPXO23ygBJpUWG+x5Tyl1WBbVZkgE0GgjIs2ofakosu32a8dr3v3U2YDc6J3XCWSG5V6q3bBrluwK/XWaYWxn6u61sb9oLb1zZMNtYwH/SLTmGIJWQkP8wh1HoHW84A7z+LNKxY8oMQSYS4Wb35g2iyZ8/IwD1eT0skCgUDbE21S402spi7ea8cazjQODPKxhUWXPxAMbbAWCq2trUU++gNBs3VpVKg93zz85slr9Xf6hiTWCdVK9NoEWq9Q6+Vrva0cfRdvTja3nEDMTgez08FkOphMB7PJ0dDgaDiPVVdj1dVY9TGsshKrrBCWVghLS4WJ1xOtHrH7Sq/zeq/jzrizU+gSYUupL4sric7Fly+OSxZGpvQ8+aJE537IFSKa0riusWRjs/YpnZen8SQ9XyAQaNui8TBvAh0/f+vdc23sSbVryRMKhVb9gRXP6tKKb2nZ5172uZe97mWve9nnXvYtrfhWPKur/kAoFFpa8Y0INCcudX30aeODMfW40h29TqHOK9R5eRrvrUFNr2BBolsiEpPpYLND1dUhXBzeUPF+dsl+Zsl+ZoKVRKumw1F5Hiu/pC0/qz16QffBNe3ZW1q+0p3i4vGaxly9E6r7Q9K2gZm2gZnOUXn74MzYjGnbK8TVsGTxRq9CgK0ItF5+wvMFAoEeRjSB1osrjsz2VtXVS3fHsTlbMLi24vE53SsO17LNuWxz4MvuXHa4lp3ulRWPL7i2NmdyXGnhvl115V6fcFzu4GOe8JqFOu+UziPUeidVritds1y5TYS5cLUeiMccuGnocDgKi9l79pQU72cSrUGEuUqOsXsFJhHmOnpZVnJMuO8DUeEBduEB5t+92Lb3Le3717QfN4gTLJ5YfVx158hs/b3RM1f7zjb2X7w1dKd7qrVfzJEYRZhLoLKfbx7c9sqj1c7RdQtMRCcLBAKlRfiByJHZjp5oaO4S2V0rHq/f6li22N2LVpfJ6jJZXCaLy2hxIgpPN1ldi1aXxe62OpZXPKuuZe/d3unKU423urhjs/ZIJgq0HqHWI9J7ewWmVo6Or3biqqHJwWaHKisx3DTEjI49xczKCqy4uIFoDRMKe0kl+40G8ek76tJqYXGlsLCUXXiAve9t9o/efFBY0lBciX18Q0y0eFL1cdWMdu6JS52X7oxcvjv2ydW+U/Xdt7oEd7qn2AJ9C1tSw+jnqezbXn9EIzMWRq9ySucRaj3IyXq86ES0sn5JgUDUFW1K54vXW1VXb7KmnW6Pw7VitDjnzY45o91gtBuMdr3Rpl/Ak9FmMNoMJrvBaJ8z2efNDqPFZXctL6347vVOv3v6GrNvakLhjNqKd1rvk815r7LkwxLLpNIer4YGB5sdKq3AcNNQKHPs2cssLRUWFzfgLh5WyTFhSTVWet6x76S9sIRZWML8iDE9qbT3CBf+7heNe9+cqqzTJVg8sTpHFXV3R49f6hqdMU0q7cwB2an67mMXO2508Jo7+TfuT55vHtz2yhFd6ZQJsWXJ3Cpysnix4J5QEAiUimjTBh+iU/Tbl+9NLNqWFm1LmFLHefnXA99+dPhbj41++7HRJx7j/P1jY08+Nl702MT3HhWcOTwrV6l0Zo1hMUoWjcGCzVm0c1a90Wa2ue2ulWut3I/OXOkcnRVgS9HbkhtXB0Tmu8OaCbktXg3nMTY7VFoqxE1DthD7cmFDyQFhcXED7uJhFVcKiyuxkmpHaYPjF+V3rnWrI78qPMDee2SqslEXv9TP3myJFtHKH4wq6u6OfspgR6awuNoLt0bu9YpudQmutY7XMPrxF4wlgf+IrvcpxuX22QWfeA49ZSAQKC1Cv7rXyhZ9UNuu0ltNVrdKvzh8pLzlTz7X86ePDv/Ro2P/5RHeVx+Z/vvPy/75EfWznzO9/ln1wd/jnf636VndrMYox0zxUmjNav2i0eLSLdg/udp7tu72oFA/rfeGtzUzvzq7sKo2++jtklGpdUxmQ1RdjbHZoZIDQtw0ZI9hf/hEQ0kJu3hvdfyyERVXCPeUYsWVjtLzjpJq7P745q8KD7D3vol9cEMfv5TZ5YukodnlI1r5/SFZYxv3ZB0rMmVEYmZxFOE0rL0xUMPox13QarVG0tBqxdn3eDX3q0dmrCrz6sycL/qUIbfMWf/yEwhEXdGk86sRSQzeoyeuDPExk9Ut05jEyvn2b/5F93/6/NgfPTKyh8bJp40V0Mb/iTb5Q5pgH81+7LPOs58R7HtkQiCTKPSzGqNMvSBVLUhVCzPKBYliXqyYEyvmZ5QLsxqT0eIam8LeP9PU1D7EU9giW5xdWNVaVltGtA8mDBypFVH1MYzdGWJ2hkpKhMUl7OL97MJi9p5i5p69zC8XNqyn4X524d7q+GUjKiwVFpYKCw+w95Qw9+xn7ilen7l9bK7wALu4Evv0nhp3wXAmml2+BCtvHZy92jJ+8nLXoMgUnnK+ebCG0V/D6D/d0H2qvvtUfTfRsuFMtFoJV47oZr96ZGZRa1mdXfBFnzUejxdJQx6PF/0rEAi0JcUEYvP9kdqmIZ3RLlUbhTI9X6Lr+soXJv/sc6NfpbWzhlns8b5hXv8Iv3+Ezx4VyI/SVuo+oz786NCYUCTTzmqMMrVRpl6YUc5LFPPT8rkpmV4g1Qmk+qlZg1RlnDM56u9xTtVe7RlXiHUr4S3K5lfV5tVJhe16r3J4xoqoshJjMkNMZqihIVRd7ag85qisxCorsNJSYekBYTgNi4uZhXur45fF1aB48+eLrZLCCqzkGJZgfrPLl2yFi3V3RmsY/bd6ZzanSywp+rFaU5otrKvdCoHaobP65Ub0LIYzEdIQBHpI0WaN/ojeOX1tgKdR6S2TYt3YlGZsSsP6718Q/sXnOX9D6+wfG52c4U+rBGK1UKIWzmhkr9Hcn35G8etHBzkCkUwrx4yRRuKMcl6smJuS6XkS3cQ0NiHCeBK9UmcZEag//PR6I7OPr7TNGv2yBZ/c6NdYAnqL72KbeHjGgqiyQshsWk/D4v2lmyopLTlQuZGGzMLCyvhlk2r/0bHiY46Pr0u2sWy0bvZMn28ePHOt/yHXk1SXH0gVCysGm19h8keftbB4PF78RBAItCXRFCZ/WJxpw4fnW2ZUJt6MfpivHuIpRwSq7q99QfzNz479A61ncJI/rZKpF2Y1RrnGqMCM0jKa/dhn5b96ZHhM+Mn96e/envlWw8y3Gma+dFz2H0pHTtwW8CXYpFg7IcI4QjVHqOHN6Gcxc01j7xn69UGBenbBNzvvVZr9mkX/ojtQ1yHtnzINSSzRKq0QRtqGxftLaTTansJCocwhxBwlFZWFe8Np2FBYWIksmFgdk5ZP7mqLKx0/K5/a0oJEOnd9oIbR38Sa7uEZ0rLCePVNmeo7ZdaloMHmV5r9kbMGAoHSKJrKHAir8W7ftTauVG0a5qvZE4oBrmJEoOre8wXZdz/L/Sda3zBPKFGHX54otCaVziz8FW3uyGekz/3B6MTUH/52tLRL88Oz3J9e4n33FO+fzk186dAIZ1I2Oa2emMZGBephnmpUoJaqTc0PeCc/rW/v50sNywrjqnoxoLX4Le7ALba6a3IeuUksLRU2nA+F75SL95fuKSwsrajGMAdmdJRWVu8pbCgsbNhT2FD4RGXqN57DM9brfabiY47CUmHNXfGWFiQSW2QKPzpsHVKkZYXxujOEDUwZLe6A3hqInDIQCJRebQbiidqmrlGFaHZ+gKvsn5APcBWjAnXPt7+g/uFnuP+b1j/CF85oFFqTSr+oMSxicxbxlVLFy7SJmhcmBTNvNE79ZdlQGX1sYJQ3xBH8pFn1pbfH2KOCiSkld1o7KlAP8VTDfLVIPt/DmT1+tpFxt0eotCoWfJqNQLw3rO2YmBuWWKNVekBYXe2orMS+vJf55T2FzE42s5PNZgvZY8Li4uI9hQ17Chv2PNFQ+EQpsmBi1XXb3rmuZvFMW1oqqZgD8rYhZXrXGVY333ixXWJy+BZdAWzRn/WLBgTKVdE0lkBY73/SOCLU8mcMA1xl/4RiaFI5PqXp/fYjhp9/hr+PNsgRTMu04TTUzll081aNziiWqflTMsmsRqGZF8vUvCnplEQhkeueuaP62rER9ih/UqTiS3RjU5phnmqYr+bPGEYFmqqLty9cvcOVzqnNq1prQG8PWNyBB1xD27h+ZMYarZtt+pID7OL9zOLihnXtrS4Mq7Cy8ImwSvc8UYosmGO6OaDmKayO5YDRGdRY/JFTBgKB0iua1hoI68NPb44KtTyJfmS9QacaFah79/5n/YHPLJZ/VvEBTf4ObfYobeYITdpUqtIuGNuOG/8PTcY4I1fPfdyl+uKbU++ylVKF/pNW9b/dlf7DWW7f0OS4QDEp1o6LMI4QG5vCBFLDpET3aX3bmYuN42IttriqtwUMNr/FHejlz7WO6lL8B5RdpTuDGhbPsOQJWNwBvc0fOV8gECjtokWGTKq62NrSL+kYnOkYlNzrmWL2Tj0YkrBef1by3OeXPv49XyPNc57mrqItvPmI4mWaXKUz/YSmO0ZT/k+aRjv/2MtjBZcVf/CWUKbQ/mXZ0NGRue/VjfcMcoe40v4J+YOhmXa2mDUi6x6d7RyWXm7uPX2uYUyk0duCc/bgnD1gXQqOiE3MYe24zAaKqFdovMlW9/AMy96AYzm44AgYsj2uFgiU26IZ7MGwzl7tuNk19Slj8NJtTmMbl9k71cORjQxyBsqL+n/yqOjw7wsO/v7krx6dfOmP5XUvqdRa2eUPJYWPat8rxLS6y32qR0s4rzdOKlRY5Q3FX5YNfdw0Njoh4opUI3xV57D0Nkt4rZV74dbo3R4RgzlQdfbymEhtsAfnHMF5R2DRHRyXLd4dwsZnbaCRmcUe/sKdAexql0yqc6z4Ai7PmskVnHMEIycLBAJlQpuBeOFaR0u/5MLN0SvMiZudgo4ByeCkkifRimTYlEQumpmdkSrkCrVSpdFgWqPRbHc4jSazVqebXzDaHU7zosVgmDOZF602u84wPyNTSmY1YrmeO63tG5O39oubHvDr74239YuvM9mbgWgPGuyBOXuALTJfbJOALrZJrnbN3h/TSrT28CB8tuWg0Rkw2ANZv1ZAoJwXTbG0FlZtY2vPmOLy3bHGNu7d7inWiGxMqJEo5zWGRf3ElVD3nlD3N0P93/JzfmSTNNodTh92znt/j3Oy1u5wdgivvtiQzxg473C6roy8cbD+e7+7mf9KXTGbP8CXaAcnVR2DM7dYwqutk13D0hvMvuMXGwakWHi7yqU11fKabjlo8a05fEHXKmXkzphcq0G7L2j2BvUrQfXymnLjHIFAoIyKxhR4wjpBbxngaRrbJm/c57f0TfeNySfFWoXWbLK4lu58NWg4FrLSQ86m0HK3n/OjBaPJ0/7NVf3x0K2vmBctz1/+G6bhq4evf8W8aDlYX3Rfvb9p6oe1Q98/dLVoUqQc5im7RmR3e0RNDwQDk8q6G+0vf3TlcpcqvN0WoadVuNIl8Q7Mejkq74RmlSoaV/syIY7KOyT39ko9HSJPq9ATOUEgECjToimNPoXRpzD6brT0Dkyq73aLmjoE7QOSAa5SKDNo52125/Ly3a+G5j8I6T/0c37k5/zINH5Sq9PZ+Gc87d80j3yg1xsYA2fLbn7lEqtSrzdcHqx4uek7F4a+f7b/+/969tujPMkwT9HDkTN7p1v6pkcE6gv112vqbnKm9YqNTYNAINBOEK1fEQrr5oCma3Cqb1zR3Cl4MCQd5qvEyoU5k8PmWF65+V9Dugo/50eSGalcoVRrsAWjKfwMUa83mMyLTpd7cdGi1xvM5kWn02U0mg4373n79lP7P/nOKHeaw1f2Tyha+sT9E8oJkfqNj86dutrbxrNHNg0CgUA7QZuB2C1dbbjZI5DNM3vFXcMyjhCTqk0Go8NiX/Lc+LOQ/Fer7KfkCqXRZHY4XUvLK0uS2tDg9x2isw6nq5V/ofRGwZ3xs06na8XjXV5eeena18rq/+GnVfmjE9PjQvXApOr+oJQvNTxgTxx668zFFn6X2JP1nQeBQKBobQZin3ztEpMjURoHJ1Wdw7JxkVaqNmnnbYu2Je+1Pw4JfhLs+Y5ao7E7nL5Vv2/VvzT0XNAzvTa412QyH7n39bvS/1t6/R8XFy3LK57V1cDzdf/jl2fyi0/87dCYKByIw3yNHDOdvsA4evp684C2bzaY9Z0HgUCgaNGiP7TzHS2sUYXO2jeuGBNpxYoFjcFqsro8lz/nb/9KqPXPkUAMOWtCd/5Mq9Uduff1G8IfXxzZ+5vre1688o3nL3/9J+9/459f/1rR219nc4QcvnKYr1HqFienZn/7xqlqBrud78j6noNAIBCimEDslQUa2idVerNUbR4RYCL5vFJnWVh0Lp+neW980d7854GmPwrd/dO1B18NdP5taP54yHxsreW/aTTYkXtfb5j44Sc936+8XVRW/4+/PPudH7z2te8e+ut//vBv+kcFg1y5VG2y2Nwfnr70+slrjF5lj8yf9T0HgUAgRDTk8wPR0rV7/a5lv1hp5M3o5VrzvNnhaviiq/4L3htfXL37JX/HX4cm/ldo5meh+bdCljfczL/SaLCrfR+9cCn/2XPf+ln1np+c/MYPj3296O2v/eC9b57rOtw7JOBJsBXv6v3ugd8crT7bPHJf4OyTr2V9z0EgEAgRGoh9s8E7o/M9Qzx/MCRVm6Rq05zZadc0LjP+o4v+71z0f7906ffdN/7Uce3P3Tf+xN66R9P13tzcnNPptFisOp1eo8E0Gkyp0khnlcJp2ShXPCGUu5aWZXLVr1878eHFttsjc72yQNZ3GwQCgeKFBmK/ItQtXW3slnEFM4G1kN7oMBgdZqtzwWjW6nQYhmk0GIZpMUwbZm5u3maze70+r9e7tLTscrmdTrfd7jQt2jCDSaUzupdWMK2h9M2qt6qbGnsULIk36/sMAoFAuMIJxH5FqEvsufJgenhCGAqFnEsem3PZ6V52uZacTpfbveR2Ly0tLS0tLS8vL3s8ntXV1UAgGAyuBQJBvz/g9wd8vlX3ste15A0E12RydembVW9UNdZ3iDtFy3CzDAKBdqzwA7FPvtY5vXK1S3r7/kAwuBZcC/l8ft+q3+8PBALBYDAYDK6tra2trYXW1kLhn4LBtWBwLRAI+AOBVX/AHwiE1ta6+oZ//dqJt6qb6jvEHVPuNKUhVl7EOMkl+rizVF914vGiE48fFjDTv+MZEla+OcpzujaXOeeZPibRR+PE04xM/HfETriAY3bz8Spsh7mNsVfelfpSPfVb3BZ+IPYrQn3ytS6x5wZbU8vonJ5RhEKhtVAoEAiGG4PhNAwTycS1tbXI7zRaQ9W5q785Wv3hxbbGHkVa24ZUCsS02iMtEDe20tXz+NYvKXKdkxCImT7mO+ECjvbgOHk4QSZmKxDTfk3iizAQw+qWrt4ZXTh3i3OR0c4VSDxeXyghgUBgRqa8cOXWoaOnXz957WzzyO2ROZbEm9Y75QSBGPlLEj2FUV7FCP95X2+vbZ7sjfkT/UlMl1usvIhxktGDtDWYDMbjRSeizjFiacP/YcbTmW2nEB3PnvpwhaCbXvf5NEOAc/zR44mcMmSFjpOHN/7sd/VstKbxT2Xsz5sNh4wdE9z6J77MDguYiS65+F2I/gHnOMddHiSc9ASWkAOOe2GQc03GX2/xVxFeMlRh/YpQfVXEcGzUVmFJArFfEeqbDXZMuW+wNWduDB2/eKe+qb1nYFwkkau1c3ML5rkFc7j3w8HRyavNbW+fuHjorTNHT1+vZrAZvcr7AmcG3inHNu+jrsvN/Yytq6cZjn6u4OlwY5sreHrjgNZXhY+g4+ThzP3Ri77uNwpj868c2qqPs7ThH+eqzfjFx2QwYm/2N91GDjWTwYg+/gTHk8j5+gqZDEb4yDAZjPBqCU5lgjTJ3NFAb9YSXWZJLrkUdyFynLdz0/eQJ71fEYoJFxxLuH8hMuoT/5pErrfIVbRxgjaXIpqzv6vn6cMxl1zyQAyrR+a/L3TdHNJfahOeutb3fi3zzdM3Xjt+5cixuiPH6l47fuXo6evv1tw9dbWX3ipoHtC28x09Mn9mXqEQ/TVLfLXh/rCNBxPbdotrD7k9ibeEu1RGFe1h4yrv6on920N0qImOZ5xzZIVcwdOHBcyYPwOJg4PMQEwQ7tu+9ggmosc58d1r5nYztrVFeOrjf5s5e/HPN+OuN8KrCG/Oop56Rai+inGyK2apVAMxrL7ZIEvibec77o2Zbg0bmge0TWysiY01D2hvDRvucoxtPHuX2JPh7ymnMRDJbHARRhuTwXic8M9vVgIxLrzQNtpWsymuitAVOk4ejlyaqaw/FwMRvy0cfXmQtZuRJm3iU09gOJP2opuu8RsluooI5uRi5etR2FO/HqZbDMSdIaJATHyfhf/IJsPPPojOSvwfZCJLOyMQN+/043ziTky8TpwVhpgMRnlVT2RxvFOJNFuyFYjbuJ3Hq+f4XcA7LLGXBzm7GXX7j2MpNhDxDWfS3ubzB5zrrb7qRNRVlKjSmQxG5GY5+trLqUCMahuncnWGD27svWG6FfVvNwlvMyM3AqilmJ0Nr43EB9ixR7WqB+fQ4U5Ejydyy4O3QrSo4k9l1A1a1IIZPiZEj8ySvvAhuORwdiH+YughvDwyeNJxH3fgnKmoA453HjN/FjYfI8ZfbzFXUcJK7+rZ3NOon6kYiKAdpLgXL1leDwj0MIJABG1HG/8Okpan6eH/3iDhaQAIlEQQiCAQCLQuCEQQCARaFwQiCAQCrQsCEQQCgdZFo3frQSAQCETv1tMkOjcIBAKBJDo37cDJeyAQCAQ6cPIe7cDJe4l79AJyhgWr62PGQGVdT9vIjEy7KNMuZttRBoELG9gGEIi7hc7x2SO1DwanMO9qMKJVf84KLmxgG0Ag7gpONQ+dbh6Zt7jdK/5oLXsDuSq4sIFtAIGY+3SOz55qGra6V+PlWKKklJq5SYEk8TxwYQPbAAIxx1mwusrPPVAuuIwOX7wWndTTKxVv//z//erZkhffeudYgtngwga2AQRiLrPqD3zMGOgYVxosHlzNWymmmotX9z3znEQx97vyox98/EmCOeHCBrZBLgSimE6j0Wh0Md5UGo1Go5WxzNlxlm1mdYtv1fVojCvRUi8scfjyts7BW8xeFntSNe/SmleoopIXDh48dCSVOXPgwgbIJwcCUUynldHpZbGJKKZHYtDMKtutkXirX8ToEcvnliKaNbhHJ6c7u4futrIam1roDTfrGUyZ1q6cX9rherninX3PPBfWM8++kHR+6l/YQBagfiCGo8/MiknEmI9R4bjLONU81CvUi3WuiCQqI08oHhzhRmdiK4sj1bt3vk6cubzvmedqLjelMjPlL2wgG1A+EDfSDm0Hiunh2+jcbB/S8Iif7Q1616DEJNA4I5JrjdJZFZKJjTc7RBrnztfh8jf3PfPchMwk0jgHeOq2Pp5I4xzkqR8MTMXPTPULG8gKFA/EqLiLT771p4i5F4ehUCguE3HnOVL7YHDazFU4IsLmrVr9PJKJN5ndPKVj5+vnv3ix5IXf8pSO3/zu9V88/+vq89c/pTf/8uDLZRXvxM9M7QsbyBLUDsSYEIz5IKZvvGYxs8pyNRQTp2EoFPqYMXB/XD8qtUck0znMi2gmdg2JxmbtO1xdY4p9zzxXVvH+2Ky9Y1j29kdn9z3z3C9e+A3R/JS+sIFsQelANLPK0NvGcPLFthZz8645TII0DIVCl9q5DayZAbE1okGJdW7RFZ2JAxzh4LR5SGLd4fr47LV9zzx34hwj/PF3Fe/te+a5196p6hhV4s5P5QsbyBpUDkQxHWn6mVll6+3CzQZi9NRdB1eqr6xnd08tRqtXtCjGbEq9ZUY9Py7W906Z+0SWna/SV9/7+S9e7BNZXjj48kuHX/u0ofW5Xx5+5tlfPverw7jzU/jCBrIHhQMxOvTip0X9G2LONg+TsuJdrTjf2TSg6eCZcdXFp4D2/+vztddZz5a89EH1lS6++Q5blspS1L2wgSxC4UAEUoEr1ZefZ93jzLeOG+PVzjXtfJW/dfLQkfffOd2wpaXgwga2AQRi7nOpnXvsxvid0YV43ePkrODCBrYBBGLu41zyHKl9cPzmZNPQPKKbwzkruLCBbQCBuCtwLnk+vTP6Sm33hQeKq/2GiBjsnBVc2MA2gEDcRYyKtS+fvf/OVc6ZVunlHv3lHn1Db84KLmxgG8AgUyAQCLQuaCECAACssx6I0nkPCAQC7XJBIIJAINC64BkiCAQCrYtW18FPl1w1+b7ZehBo58hVk+8LBKmrug5+1j3sKv+0ug6+xOB6eDEFHldNvk9GB4F2jlw1+Z7VAHVV18HPuodd5X89EJuHTQ+pcCB6Z86DQDtHrpr8Za+fuqrr4Gfdw67yn+5AlJwFgT4gL0sAABS6SURBVHaOXDX5bs8qdVXXwc+6h13lP82B6BF/AgLtHLlq8p3LPuqqroOfdQ+7yv9DBeLYrAMNRFEVCLRz5KrJt7k91FVdBz/rHnaV/+0H4qjM7lv1I4G4MnUc9JDiHyvIe+rJ2pbsO8kBuWryLc6VDEh/99WCvKeeXFfRpZGMbGWlroOfGf8rFueKRdP526KNvXi1U04Z/7EH/6knP+GmbeXbDMQRqW3F413xeNFAFH4Ieji9UltUXPtRcd5Hr2TbSS7IVZNvti9nQPo7rxb8tk0f+TnvPD8TG6rryMhqzfZl8wQ9r+jVO6r1j9K2Vzd2Z+f7jz74y+YJet5TT6bL/HYCcVhidblXwkIDkf8e6KF09+d5B1/U979YVvRzftbNUF+umnyjbSkD0t46UvDrVm3440zrq3lHOmYysKG6Dn5m/POqiwqqxzKxZhL8xxx8o23JOHYxr+jiYDpWvuVAHBRbbHZ3REggLvPeBj2MeB8UlF56dZn3avvB8A/Zt0RpuWry5y3uDEh780jBwRZt3M9pVl0HPyP+5fcPFl1kZ+TIkOA//oBPnioqOMVJw8q3FogD04tmiyNaaCBOHgVtX73Plxb9S3vv0eXJozr6v+QdfF6XdUsUl6sm32B2ZUBYU3n0M8QjTbOZ2IqrroOfEf8jF/KKLvRl5MiQ4B9rKi84eA+LmsKtKiqoGknDyrcQiP1T5nmTFRESiEvcCtC2pb34g7yDJdrwx56S0qIftPdk3xWl5arJ1xmdGZDmxisFL93VrH8cOp9XdOSGNP0bquvgZ8T/0Pm8ovO9GTkyJPiPPfhGp87IPVlUcHIoDStPNRD7hCbdnDleaCCOl4O2q0PtL8W8O8t76snS84ey7YractXkYwuODEjNeKXgxTvqjY8TJ4oKTgylf0N1HfzM+M+UYVL8IwffgQ2dzys6352OlacUiL0Co0aHLzQQx34H2qZu/jSvaG97V1lkirZ2b17RT7ljZZna4i6QqyZfPWfPgFSNLxe8eFu1/nGgNq+ovFGc/g3VdfAz49/Ou10e7Zl3u3xzd3a6/9iDL259saggXeaTB2I3b0GhniMSEohuziHQ9sR9tyDv3ZLYiSXnigrONWffG3XlqslX6m0ZkPLqyzHN+WPsTGzFVtfBz4x/m1Jv494s39yFl1u5lPEfe/CLyq+K0rbyJIHImpyXynUJhAbiyEEQaOfIVZM/q7VQV3Ud/Kx72FX+0/xdZtfwiyDQDlJNvlSzSF3VdfCz7mFX+U93IA49DwLtINXkS9Rm6qqug591D7vKP62ug88UeNIiV02+c6AEBNo5ctXkTytN1FVdBz/rHnaV/zQPIQAC7TSl8QoH5bxoBosnXarr4Gd7VFUAiEEoncu2hYcC/JMMBCKQy1CuIBHAP8lAIAK5DOUKEgH8kwwEIpDLUK4gEcA/yUAgArkM5QoSAfyTDKmBKKbTaHQxOTuWGcysMorvwS6DcgWJAP5JJnkgiloq8p568mCLYSuBaGaV0aIpY5lD2w3ExCEkpm+sPdlvtxxm0TuxvpIsBGKUi6gt405NfeKugXIFiQD+SSZxIAqqigoOtgiajhRsIxDjyy8TgZip9cQGrZlVVsYyZyMQxfQNF1FHL8rc5o+pT9xFUK4gEcA/yaRyy2zITCBGN8CI2j4xLc0yljkUEtNpZSwWPbJUzDrjWkMbv0XXE+8kNiqIoju8X2J6bLsRd9PxVkOR5WLmIzgOuNvGaWlvHOrUJ+4mKFeQCOCfZLIWiNE/RwVSdDNmvXEUu65wqMR+jm83bSyLbiWyHMHmE9oPbYRXlNfIpqNvzKN+T4vZJM6Nd2IjyMEL/zJ2tvVPqU/EX32OQrmCRAD/JJPBQIxvC20WP1qbG2GB1zKLD8ToOTY/4y1LGIiIF2Q5wnv7uHXEB8zmLPHN0Ji2Y3y24a8x0q4kyM3wMqlPxNmt3IVyBYkA/kkmSy1E9KVLzA0xUrJbCETcMMEPxMhHPKtbD8TYHcJN6M25kx8HPMysss37f2ghpgblChIB/JNMFgMRL3HIayFufN7a6x+CQMTfDPEjU0JPCYkEGjxDTBnKFSQC+CeZbD1DJGqtEDxD3JyVOBBTeYYYs8mNiCJKvqRvmfECUUwnaCGK6XgbStZqM7PKov3Hrxn3D0KSibsIyhUkAvgnmeT/dhM9cETiWNzi/yHGzhNJhc3J6O0o7lNGgrfM8e89kPVsTiAKifg33AlumaNePLPouIGIvGSOvZMlvmPG+WdI/KO0pYm7BsoVJAL4J5nd/dU9EhtN8H4jK1CuIBHAP8ns6kAk8yYy2X8+AhmBcgWJAP5JZjcHIskP1fBuwYEMQ7mCRAD/JLObAxHIfShXkAjgn2TSOaZKXQdfKJ0DgUAgigpaiEAuI6RaCwUB/JMMBCKQy1CuIBHAP8lAIAK5DOUKEgH8kwwEIpDLUK4gEcA/yUAgArkM5QoSAfyTDATijmEnfHnl4TzswG9LU64gEcA/ySQJxPCAKmFVcbYQiOHv7UYXV6b7WontjnqH1WUqJOwLcXs7teVRA5BvZ28xHFMMRPwuwjMzSgzlChIB/JNMwkCUdx480imKJGPRpb6tBGJZWRl6GWc4EGN7baBaJhIEIqk7RUILcaPjoFBc/z2ZGCWGcgWJAP5JJuVbZnnnwaKKJvlWApElji7h2EDEaSUQdvGP36EqWgmxtYz0NIY0KMJFiTc0Cn7zBR0dJYENgs3Rko3EUsZiJQnE+M7Mkvok7l4I6SkXxwNBN0IJjiqRP+LMynwPj5QrSATwTzIpByLn0pZbiCxzdCcGyQcSiZrDzKKXlcUlZcLrPyY7ogdkwhntJGZolOiWV4KRXlLr1TX55gg6hRTT8aKDYKdS8xn/ZwGna0VCDwk7msTdzRQ6AI47WpnuA5xyBYkA/kkmxUBMqY9YnECMKqbNGiEcSCRSUGZWGV28UXSxCyaIos2V4t9Lxa4Ip3P/5MYi60mh3Ik2FzOgCo6L5DuVos9ECRW9y/geEndFjrebaEs+2SGK/VOYmVFiKFeQCOCfZFIKxL7agryNh4lbDcRIISO5FstmC2f9Doou3njYhH+rHV8GBN2vIlsjCkT0Tjh2RXGRQGwj+eaI4ivpSxWcPnST+CQONdw7UOJATPRggIbbvk5wiDa94TUzoYUYDfgnmeSBmGIaEgfieqGwiNpn0YQX2xw7IPykL35mnEYLfmMBvbdM2kLENUbURoqbnsrmtttC3CRln5lqIeLvJu5hwj90aBMeniESAP5JJnEgGpqOpJqGiQIx0lrAeXaGIKbTyuj0skgl0umEQ5FsNRDFm6OdxD1DjP+RaC2JbRBvDicQo2MhxlGynUrZZ6JniMk8JHqGiL+buIcp/kyZWWW4r8Ti15L6REIoV5AI4J9kEgYi51L0gCp5Tz2ZVyvYViBuFBv+G8+Y8ogusNgPsTeQcYVA9Dgp6uVuZLQT5LUvei8ZZyy28pLZINgcntHNrdHF5s3/R0m6Uyn5TOAb/716jAfc+9+YLaG7iaQWwSGKeQoQNUPcJrY2kQDKFSQC+CeZ3flNlRRfggKUh3IFiQD+SQYCEchlKFeQCOCfZCAQgVyGcgWJAP5JZncGIrBboFxBIoB/koExVUAgEGhd0EIEchkh1VooCOCfZCAQgVyGcgWJAP5JBgIRyGUoV5AI4J9kIBCBXIZyBYkA/kkGAhHIZShXkAjgn2SoE4hJe3oCgDgoV5AI4J9kUh5TJVnvsAa8MVWIv/K7dXACEe0Gi0KBidOZA14f1FuYCOBBuYJEAP8kkzgQBVUbXd301RYk7tkhPhDTHE8EgUjBRAh3HiOO6+o0vgOa1CcC+FCuIBHAP8mkesssaqlI2g9YCoEY3aYj6mMmanp0vyY4Q47gBWJ0z1gxXTKXbWUQFaQ7nNguSdGJ+Obx5iQymsEOAXc5lCtIBPBPMikGoqCqaJtDCESRaFgPoum4w31ErzA+DjYWQ6NxK4OoxMxP3M0q8RqSJ1VMIGauy+hdDuUKEgH8k0yyQIx0iZjsfjnhM0S6OJRyp80pdOa8AfIMMTKzmE6jlZWhwUHQRTbu4CQJ+riOH0sAbw3JBxVJEIjpHFRkl0O5gkQA/ySzlVvmbYy6F02Kw3qkMNwHOmc8SM+yWx5EJXmXrjFNSZw1JB1UBFqIZEC5gkQA/yST0XGZE8dXelqIBEOdhIcnJnrWlnQQFeJA3JwUidTEt8aJhh+AZ4iZhnIFiQD+SSZhIMo7D27cKaehhUg4rMeWh/uIXiH+AEaR5l/0iCJbGEQlaSBGZkjaRiPKrPh734wMKrLLoVxBIoB/kklhkKn1/0NM0jxM7S0zwbAeWxzuI/7Xm4smeseR+iAqBIGIP1QI3hoSjbuCjioSd/edzkFFdjmUK0gE8E8y1PmmykMBt5a7FMoVJAL4JxkIRCCXoVxBIoB/koFABHIZyhUkAvgnmV0SiMAuhXIFiQD+SQbGVAGBQKB1QQsRyGWEVGuhIIB/koFABHIZyhUkAvgnGQhEIJehXEEigH+SgUAEchnKFSQC+CcZCEQgl6FcQSKAf5LJhUCM/rYefLsXiIZyBYkA/kkmpUDsqy3Ie+rJrXQQu/5tW/xv8UZ3+pqOL+NSJRDxetaO/R50TC82ib4zvVN3ccdBuYJEAP8kk0Igci7lHblUdWRLPWabWWVIF62hUCgkptPo9PT3aEqNQIzqnALpFTzOLwylkjYoV5AI4J9kkgaioelIQRXH0LT1QKSLY7u8iZuGdkyD9OCC0yDCH72EMBAJ1oA7WMoWx3sh7B8s2VAqkZmIhxqAbhDTB+UKEgH8k0wKw5DWCsKxuPVAjOtqOnZSwrFKoltBYnoZy0w4/glRIK4vFTszwWApiQdXIRjvhWCMgRSSKnbPcboBg46y0wTlChIB/JNMsg5i1zuF3WYgxnZrupFq+IEYGyTxt76E45+kcMu8mVMJgoxoaBS83rxTH3QFB/w4iywKQ6mkEcoVJAL4J5kEgRi+Wd78eTuBGAmo6D5W8Vp26Agk8RVPPHpJooYe+sIiUZDhrJxovJfUB12Jg/gB4PrGoIWYRihXkAjgn2QSBKKgqmiju+yIEg7NjBeIcU8OiQJxnagAxWkhEo8oFR+IaDRu61Z3qy1EfFOxU4mSLJJy8AwxfVCuIBHAP8mk+H+I224hxv0HTpJAjGlaxj5DJGwWJQ3EqDH4iIIs0eAqSR5cpjrei5lVhs62+Zgz7i0yDKWSFihXkAjgn2QyH4jIczXcQMQdgQRn5BDc8U8Ib5mj3iWz6EkCkXDlKYwDE9UATjCUCjqSCm39FRPuymEolTRBuYJEAP8kkwvfVAEAIihXkAjgn2QgEIFchnIFiQD+SQYCEchlKFeQCOCfZCAQgVyGcgWJAP5JBsZUAYFAoHVBCxHIZYRUa6EggH+SgUAEchnKFSQC+CcZCEQgl6FcQSKAf5KBQARyGcoVJAL4JxkIRCCXoVxBIoB/koFABHIZyhUkAvgnmcSBaGg6EtXhTa0AAhGgFpQrSATwTzLJA3GjS0RoIQLUg3IFiQD+SQYCEchlKFeQCOCfZFK+ZS6qaJJDIAIUg3IFiQD+SSbVlyqiloq89fFVIBABykC5gkQA/yST+ltmQVVRkttnCERgp0G5gkQA/ySTciDKOw8mu2uGQAR2GpQrSATwTzKJArGvdjMB+2oLEo8wBYEI7EAoV5AI4J9kErYQOZdSHG8PAhHYmVCuIBHAP8nAN1WAXIZyBYkA/kkGAhHIZShXkAjgn2QgEIFchnIFiQD+SQYCEchlKFeQCOCfZGBMFRAIBFoXtBCBXEZItRYKAvgnGQhEIJehXEEigH+SgUAEchnKFSQC+CcZCEQgl6FcQSKAf5KBQARyGcoVJAL4JxkIRCCXoVxBIoB/kkkeiKKWihT7iIVABHYalCtIBPBPMkkCUdRSkUq3DhCIwM6EcgWJAP5JJnEgCqpSGDkAAhHYsVCuIBHAP8kkDER558GiioORYVVgGFKAalCuIBHAP8kk6w8x0kKUdx6EIQQAqkG5gkQA/ySTNBAjA0sZmo4UHGwxQCACFIJyBYkA/kkm+S3zxjNECESAelCuIBHAP8kkH5d5PQSjb58hEAGKQLmCRAD/JJPs/xDlnQeL1l+qJH6ACIEI7EAoV5AI4J9k4JsqQC5DuYJEAP8kA4EI5DKUK0gE8E8yEIhALkO5gkQA/yQDgQjkMpQrSATwTzIwpgoIBAKtC1qIQC4jpFoLBQH8kwwEIpDLUK4gEcA/yUAgArkM5QoSAfyTDAQikMtQriARwD/JQCACuQzlChIB/JMMBCKQy1CuIBHAP8kk6/4r3DVsRJu9gUEgAhSAcgWJAP5JZgstxL7agsSdZkMgAjsNyhUkAvgnmZQDMaZvRAhEgBpQriARwD/JpBqISZuHEIjADoRyBYkA/kkmxUAUVCUbUAUCEdiBUK4gEcA/yaQUiCmOzgyBCOw0KFeQCOCfZFIJxJSahxCIwA6EcgWJAP5JJnkgiloqEv+3DQQisGOhXEEigH+SSRqIgqqiJIPtQSACOxbKFSQC+CcZ+KYKkMtQriARwD/JQCACuQzlChIB/JMMBCKQy1CuIBHAP8mkORBpALCT+MZffYlGo2W7yrYP5QIFgXL+aa6a/DTqG3/1JRBopynrI3WAqCJaSFKVLrlq8rPdIACAGL4BLcSsQjn/6Q/EbO8RAKwDgZh1KOcfAhHIWSAQsw7l/EMgAjkLBGLWoZx/CEQgZ4FAzDqU8w+BCOQsEIhZh3L+kwVie0lkQJXyK+9BIAIUAgIx61DOf+JAfP1y0Y97RqpCkqrQyKHyyM8QiAAVgEDMOpTznzAQRw6VF5VI4sMRAhGgAhCIWYdy/pPcMkuOF+QVlUgk7/UcKoBbZoBaQCBmHcr5T/5SRXK8IO+pJ/MOHVqElyoApYBAzDqU85/0GWLB5faqkKRq8cqP8+CWGaAUEIhZh3L+EwXi4pUfRzUMk981QyACOwoIxKxDOf8JW4jtJXmRlyojh8o3WosQiAAlgEDMOpTzn8JLFfg/RICaQCBmHcr5h2+qADkLBGLWoZz//w/f6PrMyw7deAAAAABJRU5ErkJggg==)
Now the amounts should be displayed in column B so that it can be processed as numeric values.
In excel function to extract last part of a text is not available.
So I have added a new function in macro like below:
Function LASTWORD(strSting As String) As String
Dim strLastWord As String
Dim arrWords() As String
strSting = Trim(strSting)
arrWords = Split(strSting, " ")
strLastWord = arrWords(UBound(arrWords))
LASTWORD = strLastWord
End Function
Now you call this function from any cell as a normal excel function like below
=LASTWORD(C10)
He has a file which contains multiple data records exported from some accounting software. Each record contains an amount as the last word of the line. Like follows
Electricity Charge 3000
News Papers and Periodicals 2000
Food Expenses 1000
Miscellaneous 2500
etc.
His requirement is quite simple. He want to calculate the total of these expenses. He copied this text to a Excel wok sheet. In Excel work sheet one line of text will be considered as the content of one cell. Like this
Now the amounts should be displayed in column B so that it can be processed as numeric values.
In excel function to extract last part of a text is not available.
So I have added a new function in macro like below:
Function LASTWORD(strSting As String) As String
Dim strLastWord As String
Dim arrWords() As String
strSting = Trim(strSting)
arrWords = Split(strSting, " ")
strLastWord = arrWords(UBound(arrWords))
LASTWORD = strLastWord
End Function
Now you call this function from any cell as a normal excel function like below
=LASTWORD(C10)