Sometime our data contain unwanted leading and trailing spaces in excel. But dont be panic. Removing it is very simple. Yuo can use formula
=TRIM(A1) where A1 represent corresponding column name.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA4MAAAD9CAIAAACJNTWBAAAgAElEQVR4nO2d7XMcxbn29+/IP7D5lm/7bV3l/ZRKpZ46dSpVPMWTPMBJAvFynJDFknXgyQuHExISlENOsshhhRKSQAQuXoSN2CxG+AUjwLYkZBlh2caRLRtY29heG8tAUvt82NVsT7/N2/Z037PXr+5y7Y56Zu+9tqf7cvf0TK4NAAAAAACADXLL59cRCESaYfusBwAAAFwBThSBSDtsn/UAAACAK+S+98gLCAQizbB91gMAAACukJuYnosXrWrhs+N/QJiLVrXw2T/+iRBjYnrOeg5JwvZZDwAAALhC7thaK0a8OL/eqhZuLtcQ5qJVLdz4/AuEGBPTc9ZzSBK2z3oAAADAFXLPvPFxjOg60ffGEOaiVS1cv/k5QoyJ6TnrOSQJ22c9AAAA4AqJnOj6sd8hzEWrWmjd+AwhxsT0nPUckoTtsx4AAABwhWRO9OijCHPRqhauXL+JEGNies56DknC9lkPAAAAuEIEJ/rW8SucE72xOIowF61q4ZNr6wgxJqbnrOeQJGyf9QAAAIArhHWib75/+bPPv+Cd6LsPU4m5XxTzmzeNTdnPJHy0qoWLV2/YjrPPby/mN2/qRmn8oP2UbkxMzxk8/un61tLGV95eXzHwEbbPegAAAMAVQjnRg8uf3Fi/eWP9Ju9E5x8iEtvGSv8y9tC/5B/aZjuTCNGqFpqXP7UdZ5/bXty666z3Or9jznZKn05MG8vhnVq+tP25U923y7u2b3z3fobtsx4AAABwhWAn+saxS61rNzrBOdFP5/6TRjz/zXz5rjOv33VP6ZtHrCcTOlrVwkeXrtuO1Z3DxbtfWu28fe+l7fnh6fdsZzUxPWfmyEceLRUffct4/rbPegAAAMAVApzo/qWLn1y+5gXvRI/8hEQc+VnxnvHtnx7ZvrvceWE/pTDRqhbOX7hmO1afHSqWX1wVXtuMiek5I0deeblcenyv+fxtn/UAAACAK+ic6L6jF5oXr7DBOdHrh+4nEHv+7Z7S13fvuf/6oftXH/96vvxvq9ZTChetauFs86rtOP3XIfY60eG/Hree0tWJ6TkjRz64I1/aMWM+f9tnPQAAAOAKSif6+rvN8x9f4oJ3ou+MuB+rv/9afsvtq523e26/p/S13XvsZxUmWtXC6kdXbMcHT28rbnn+g+7bAzvypaGnly1nNTE9Z+TIB3bkSzv2mM/f9lkPAAAAuILcic4sfHzmXFMMzolee3ub87F11xZmSG/zpvzmTffs2Go7q1DRqhZOn79sO079ZVvxrudObbx9+5el4i/3W85qYnrOzJFT+na2z3oAAADAFSRO9LX5j06fkQfvRGd/6Ho884186au76hVvy9/HvpovfePQbMXUJ/YvWtXCqbVPbMfJP99bvHPnye7bvWP50tCfj1rOamJ6ztCRD+8cYr/g4Z1Dve/ev7B91gMAAACuwDvRV498eOKDc6rgneibWx2PQw8U8w/c7t94+2Ol4mOT9nMLjFa1cOLMJdtx4sl7fYPKP3/dekqXJqbnzB38nWe39b7vvVPvGPgI22c9AAAA4Ao+J9o4fH555YwmOCfaOlhGGIxq4fjqRYQYE9Nz1nNIErbPegAAAMAVEj13vnXgToTBqBaWT19AiDExPWc9hyRh+6wHIA6PPfsGAoFAxA5V25LIiV7d/22EuWhVC8dONRFiTEzPWc8hSaTpHgDoF0/vOY5AIBCxQ9W25F6cX48XrWrh6r7bEOaiVS0cPfExQoyJ6TnrOSSJNN0DAP1i6q0PEQgEInao2pZcq1pAuBkT03OITEaa7gGAfvG9R15AIBCI2KFqW3LtY6PxolUt5IBJvvLlL+VyuTR7GiosLJ+znQIAAGSHDy+1Hn5q308n9uw6+N77qxfeX83y5ewaSwSskNSJ2s4/s8CJaoATBQCAflF/+/jw2Cv73/37zc//6cXnX2Q24ERdA07UUeBENcCJAgBAX/j1Mwf++5mD5y9eu3bjCzY+vfmPrAacqGvAiToKnKgGOFEAAEhO/e3jv55849K1z8W4cp1knDx97vD8MX0ZOFHXgBN1FDhRDXCiAACQkA8vtYYee+Xkh62PrnwmxoWr9GLbyE+++X/v/Nbtd/34gV9oisGJugYlJ7pUy+VqS2l+okXgRDXAiQIAQBI+/+IfDz+1b/rtk2sX16Vx/hKxqD7+p1tuvePYiXM/HPp/P3v4N5qSrjnRZqNSacS7z/RSLRd3V5fgneiFJ/81v3nT0JMPRnOiSzVvxbc5rwgnCjrAiQIAgmg2KuzNSHydR+dvWejD43L8zIUfT+w5/dENNj748Prs3Mqu+v6dL77W2Hv41PnWavMGlbj9O+Xy94fDlIziRBlz46tLytrFGJVuGd62dA7Zq3wSN9kpIvodsd4mcLEOwTrR+54oFYeevG/P94vRnGizUelJtlQzpgqcKOgAJwoACKLZqHh9NttLLdVyuUpjifnrILLz9cWn9iytnLvuxfG1a28ePlp/9cDzLzX+MjlV++Ozf3jqxfdXL588f93xuHfkgVtuvaMTt37rO4Hl44yJNrn64nvPmhPOiVYqfD1bquVqtZpvZ4kRrdRqFb/hUdTbTIyKirPzD8ZyojIlmP8zbOjZse/efzLY/1h4R+DK+P7jwPww7P9IMuhP4UQ1wIkCAILw9UxCN6XqtwaFXz9z4LWFs0tnWl4cO/XRkYWl/QcPsWb0pcbs8tlr7sev/ueJW269o/rEZJjCfXeirB3knGhtyW8VhW2SIbbOXzslg/LIhhXthxOVT3T0BkcZ5TolO+L6Bq6FMuwb5n+ykv92ZLNFgRPVACcKAAiCHxP19xKZ7Dfa7XZbMpks60fur/1t/7GP509f9WJl9aPl46c4M/qXZ6cXT191P34w9KNbbr3jnfc/Xjx9dd+RD3bNHFk8fXX/kQ9e2feuWFjpRMWpeOV/ZVQj7qIT9VlFYZOkHm78UVpF5TWZ+mhcX5xou937BVWDoz3D6Unme9P79ThZe7+Yvwj7QVn4PwEHnKgGOFEAQBDclXxcH5FZJ9oWzKi0zPDYK/uPNg+duOLF389fWj17njOjz7746pGTV9yPb9521+3f2Xrk5JV//+F9t3377kd3PP3b2jPfLd9bGXlALNyvMVFp3RKdKLNpw6vIfI34QbI6qnGuhOmbE+3QbFT8w5ncBHo8J9r7Df3DqZpWhjxwohrgRAEAQQjzp5rZ1cyht6Htdvvhp/a9/PbZN5cve/H+mSvNC7wZ/duBxbeOX3Y8/vbWiVtuvaMy8l9vHb88/cb7P/n572659Y7bvvPvqvJ9np33m0mJE/W2eZ5R7UT115TAiYa8i5P4nwBDY6LUR6MDgBPVACcKAAiC67O5Lj/jTrTdbuu7j/Hdh/7YeG/f0iUv9h+7dO5CizWj+2YX9h9tHjh2yfF4+Hd/vuXWO3712FOdtz8cefCWW+/4jwdGp988KS1vYnZetnqJtz4+NyN3ooHDbHCiCifqu4mA9/9ORt6lWuQx0ZxsdJpfkkZcej1wohrgRAEAQQz0mGggh5bP/vQPe1999wIbry1eWPr7JyfPXnzvg/NvL5197d3mzOJF9+Oe7Q9+87a7ZhYvfqd875Yf/Mdv//jSHd/9wa3f+u4dd/5AWt7IiiXJghbG43A3dFJdJ8rXUv8lqLI8sjEyx9/FKb95kxd6PyqsWOLtO7P6vVGLPCbKrq8XivAfmr3JeThRHXCiAIAg+OEldklJli/tCseNm5+P7KhP7js9faQpjb/NEYj//X++PfZ041u3b/nZo0/+ba753N73w+zVfycqvYzQ53H8llKxdl52q0pvm6reZmBI1MVnLGXB4CcHTlQDnCgAACTk0PLZoR2NF2bPv/T2R2LsPvSx+zH040e+P/xfD/z3HyPt5dYzlhI6yUzcaB1O1F3gt1RAGQAASM747kO/+Ovbz735oRgvzGY23HKiyaxoJowonKiTdMbeO2OiGBYVgRMFAIDkXL2+Pjz2yi+fPTx54DwXz76R2XDMieK584mdKOg7bTjRIOBEAQCgL1y9vv7b597cNvbq71858afX17x4am9mwzUnCnKtaiF2fOXLX0L0PRaWz4lbEFkK22c9AAD4eHNp9d7fvfzAn2b/56XlJ/acfWLP2T++ltmAE3WN3NrF9XgxMT1nb9wwy7QxJhoEzBwA6fO9R15AIBCI2KFqWxI50TQbwYECTlQPnCgAAACQDeBE3QV+SwWUASB9ls+vIxAIROxQtS1wou4Cv6UCygCQPta7MQQCQTpUbQucqLvAb6mAMgCkj/WLzBAIBOlQtS3ZdqK0b00Kv6UCygCQPhPTcwnjs3/8E2EuWtXCZ8f/gBCjVS1Y/3WSBPVzx8tf1bb4nOji1Ij30PnRWVNO1P/wVKNGEU40m0AZANLn2Fordrw4vz4xPXfj8y8Q5qJVLdxcriHEaFUL1n+dJEH93PHyV7UtjBNdqZeH64ueJS2Nzxhzot4zAZqNikkzCieaTaAMAOnzzBsfx46OE71+83OEuWhVCzffG0OI0aoWrP86SYL6uePlr2pbFLPzK/VyaWRyxbgT9T00tdmo8COlHSvpjaIy+0kKixvVu7NFXTWr8FsqoAwA6ZPcibZufIYwGNXC+rHfIcRoVQv2f50EQf3c8fJXtS0KJzo7ns6YaLvZqHTfLdU2tva2df1i9w1jWqWFl2o9s9kpoNrd95o5glvAb6mAMgCkT3IneuX6TYS5aFUL60cfRYjRqhas/zpJgvq54+WvalukTnRtcrhYnlozd52oZ/xY89ijN6nun173j6byhVl3KRzItzvvPaXHtQ/8lgooA0D6RHWfbx2/wjnRT66tI8xFq1q4sTiKEKNVLVj/dZIE9XPHy1/Vtkic6MxYMb9xwajxFUvy+XZvxlzpRCWFJX5S40Q54EQpAWUASJ9INvTN9y9/9vkXnBO9ePUGlTj4eDG/edNvDtnPJHy0qoUb7z5sO3768t1Fb+lzvnTbnP2UHm5VCwaVP13fWtr4ytvrKwY+wsy5c/b57cwvZbK2e/mr2hbeiYa0of27TpTZyl0d6n/l21NaONqYqKPXhrLAb6mAMgCkT3gbenD5kxvrN2+s3+ScaPPyp0Ri7tHS9kd3bM/vIJTzp61q4cb8Q7bjRy/fXayM/8h7nX9om+2UHmpVC6Zkf6eWL21/7lT37fKu7Vt3ne37p5g5d84+t73Yy/adWn7zJhPJs/mr2hbWia5NDoe1oUad6FItaExUXlh+nahsSNXZS0N9wG+pgDIApE9IG/rGsUutazc6wTnRjy5dpxFvPZ4fnn7vxPTdpcf3W08mdLSqhU/n/tN23Le7XLxn/L7O2zPj/ytfvuuM7axa1YIZzY88Wio++pbxX9bMubO6c7h490urvS1vPZ43U+G9/FVtC+NEZ8fZcdr85k35sfn0nCgza19pNGpBs/Oywuy0u2zwU1gq5fbkPPyWEigDQPqEsaH7ly5+cvmaF5wTPX/hGonYO1Ysv7h6/sLqs0OdF/ZTChOtauHTIz+xHdt3l4v3jG8XXtuMVrVgRPOVl8ulx/ea/2XNnDti9T7861Lx128azF/VtmT7GUu0gd9SAWUASJ9AG7rv6IXmxStscE70bPMqgTi+e0tp+K/Hr55tXn33heH80O53racULlrVwvVD99uOe3eX2etEv757j/WU7m9VC0Y0P7gjX9oxY/6XNXPunP7rUHHLC6eZLYceKRUfOWgwf1XbAifqLvBbKqAMAOmjt6Gvv9s8//ElLjgnuvrRFfdj/vmh/LZd8523y7u2lIaeXrafVZhoVQvX3xmxHZXdW4r3/L7Sfbvzlnzpa7v3WM6qVS0Y0fzAjnxpxx7zv6yZc+eDp7cVtzz/AbPlnV+Vir86YDB/VdsCJ+ou8FsqoAwA6aOxoTMLH5851xSDc6Knz192Pk79ZVuRu1DtrudO2c4qVLSqhWtvb7MdW3dtKd6zY+vG2zsfKxUfe9ZyVq1qwYzmb/+yVPzlfuO/rJlz59RfthV9dXv/WL401jCZv6ptgRN1F/gtFVAGgPRR2dDX5j86fUYenBM9tfaJ67F3LF8a+vPR3pbDO4fypbG69cRCRKtauDb7Q9tx964txXvG7u6+feYb+dJXd9UrdrNqVQuGND+8c4itMId3Dt2582TfP8XMuXPyz/cWe9kefenOUtFE8mz+qrYlNzE9FzsWls8hEIiokaZ7AKBfSG3oq0c+PPHBOVVwTvTEmUuOxyu/KeZ/M+vfOPvzUvHnr9vPLTBa1cK1N7fajjt33eUbVH5s0npKW1vVgjnZ33l2W+/73jv1joGPMHPunHjyXvaK3m1PvmtKIi9/VduCMVF3gWVRAWUASB/RhjYOn19eOaMJzokeX72IMBetaqF1sIyQRLVg/ddJEtTPHS9/VdsCJ+ou8FsqoAwA6RP+zvZidJzo8ukLCHPRqhZaB+5ESKJasP7rJAnq546Xv6ptgRN1F/gtFVAGgPRJ7kSPnWoizEWrWri6/9sIMVrVgvVfJ0lQP3e8/FVtC5you8BvqYAyAKTPi/PrSWJieu7oiY8R5qJVLVzddxtCjFa1YP3XSRLUzx0vf1XbAifqLvBbKqAMAOnTqhYSRpIFsojASP4DZTWs/zSITqjaFrpO1P8kzywCv6UCygBggWOjSaJVLdj+Alkml8t95ctfygEZHWVs/0Txod7lBebvc6KLUyMb6/nHZ2I5Ue9x8LlcLmfWKMKJDi5QBgALwIk6TAb8liEyoAz1Li+SE50fHa4vXlxfu7g+M1bMj83Hc6KVRvei1GajYtKMwokOLlAGAAvAiTpMBvyWITKgDPUuL9qYqG9wdMOVxnainRHSrllsNir8SGnHSnqjqMx+ksLiRvXubFHKZpV65TMHlAHAAnCiDpMBv2WIDChDvcuL50TnR0vF8tRawjHRdrNR6b5bqm1s7W3r+sXuG8a0Sgsv1Xpms1NAtbvvNXMEelCvfOaAMgBYAE7UYTLgtwyRAWWod3kRnejsePc60aCp+TBOlDWPPXqT6v7pdf9oKl+YdZfCgXy7895TelwaUK985oAyAFiAmhOV9BvZxYrfIqFwBpSh3uUlmJ0PWrQUvGJJPt/uzZgrnaiksMRPapwoB5xo1oAyAFhA5i8vPPmv+c2bhp58MJoTZboKc06GhE/qF7zfgsIbZEAZ6l1eTCe6tlIvl0YmVxJeJ8ps5a4O9b/y7SktHG1M1PkzIxzUK585oAwAFuDN5X1PlIpDT9635/vFaE7Ut5q1dzlW3yHhk/qFz29BYYYMKEO9y4viRFfq5Y1J+SRjononulQLGhOVF5ZfJyobUiV9aagP6pXPHFAGAAvILeaDsZyorJGWL2ytNJreKFZtqVeIvU0LW6Z3ZL8byMhKVhWC34LCXTKgDPUuL9KY6NrkcHHjfqIBA6LRnCgzHF5pNGpBs/OywuxPKRv8FJZK9SBrS6lXPnNAGQAs0C8n6l9vuoFmYWuvy/C9kS1+Zce8MrmSVYXPb0FhhgwoQ73Lizs7HyJsP2Mp+1CvfOaAMgBYoG9OtN3ujTioBqgkAxa+N73unbskqzcs4S+SkZWsKnLCuhwo3CEDylDv8uBECUO98pkDygBggb460Q7NRsU/pMRNYsZzA8xFXb4hLRZXfFK/EP1WByicAWWod3lwooShXvnMAWUAsIABJ9rry0MsbE02LuXQlYsmUPktKJwBZah3eXCihKFe+cwBZQCwQJ+caGeVR/eY3mLUEAtbNW7AN7jFLjnolnfqwkUjsH4LCrNkQBnqXV6wE52YnosdC8vnEAhE1Ejn5Aegz8ju4tRd5Lp5U+BdRYUVS/xMZeDCVu24FLvGWSjCf6g7U8d9IydZlwOF2+1MKEO91wjMH2Oi7kK98pkDygBggaBRz1iz88lxeGI4RdRz0MmhrXAGlKHe5cGJEoZ65TMHlAHAAnCiDpMBv2UOY10GnGgo4EQJQ73ymQPKAGABOFGHgROV0pkP7yhjQBw40VDAiRKGeuUzB5QBwAKOOlHQbjNOFHi0jTvRlKDe5cGJEoZ65TMHlAEgfVrVQsKwvlgww/GVL38JwYUoi/WfacBD1bYMiBMlObmg+dkGHCgDQPrE7iwIdhn0yGFMVKCNMVE3CMxf4kRnxor5zZvKU2ummxXvzge5XC5n1ijCiWYKKANA+sCJOg4aRhE4UReI7kRnx/PD46PDxXScqHdfrWajYtKMwolmCigDQPrAiToOGkYV1JXJfP6cE12bHC6Ozq5Npu5EhUcScCOl3P1jmf0khcWN6t19t5x1y6xSr3zmgDIApA+cqOOgYVRBXZnM5+9zootTI/mx+Y4fTduJ9h6ItVTb2Mo8JMv3TC3fo7kkhb1neHkFVLsLz5t15rEQbfqVzxxQBoD0gRN1HDSMKqgrk/n8GSe6Ui+Xxmc2RkZTdqKseezRm1T3T6/7R1P5wv7HbLU1u/PeU3pca1CvfOaAMgCkzwA4UZLXcXlYahgJiEZdGepdXngn2pmX771Oe8WSfL49lwtyopLCEj+pcaIccKIEgDIApI/YCyxOjXgPnd/oPvrfZWBta0jYhhGisVBXhnqXF96Jzo+Wil6b0o3h+mJ614kyW7mrQ/2vfHtKC0cbE3X3DKJe+cwBZQBIH74XWKmXN/qIxamRfHdKzYgTxdrWMHB+C6J5UFeGepcX5y5Odq4TZbf2LgINGhOVF5ZfJyobUnXt0lAf1CufOaAMAOmj6xFW6uXSyOSKcSeKta0aVH4LolFXhnqXR9CJMoPnlUajFjQ7LyvM/sqywU9hqVQPl2wp9cpnDigDQProeoTZ8XTGRLG2VYPSbw28aNSVod7lxXOioYLC5ee0oV75zAFlAEgfdXdgdvACa1tDovJbEI26MtS7PDhRwlCvfOaAMgCkj6ovmBkr6hcVJHei0mkrrG3lUK7LGXjRqCtDvcuDEyUM9cpnDigDQPoksaF9m51nt2Jtqx/11ZDM1oEUjboy1Ls8OFHCUK985oAyAKSPdFI+pA016kQHfG2rRyS/NVCiUVeGepcX7EQnpudix8LyOQQCETXSOfkB6C+8uZwd52/8NzafnhPF2laBhUC/NaiiUVeGeq8RmD/GRN2FeuUzB5QBIH1idxboMtIBDaMK6spkPn84UXehXvnMAWUASB84UcdBw6iCujKZzx9O1F2oVz5zQBkA0gdO1HHQMKqgrkzm84cTdRfqlc8cUEYFd2sQ2+koEXPjtoj5J/86GnEcl8sR4EQdBw2jCurKZD5/OFF3oV75zAFlNLCOSu+uonovTflIh5La0EBvqvqU2B/dd6ebeZIsb8UiVwQCoWpbMuBEXbprWV/R/GwDDpRREd5dqVydSOChkmTobQmTecIcNB8BGxoGjIk6DhpGFdSVyXz+rBNdmxwuhrwfR2Cz4nuMgVmjCCc6cEAZFaK74oYb2Y3hp6Sl9lQ8PvsnzadLc47hRKUfLX6odHcMiMYATtRx0DCqoK5M5vPnnejobH+aFfbOWc1GxaQZhRMdOKCMCqnFlL6O6r24g6iGS6VmVHoQfT4hx0SlJluzu8p/w4mGAU7UcdAwqqCuTObzT8OJ+p5IwNzP1f+0LOZOsbIHwfa8Jr9Rvbvv5rH0zCr1ymcOKKMi/FhgoFfT283wx9cMVUo/KOQXkX504LcL8xWACjhRx0HDqIK6MpnPXzE7XxqZXOmfE+092qrzCCz/tq5f7L7xPUZLUlj+QC3Z7sKzYZ18KoYG6pXPHFBGRZhRQ1XJ8EeO7UTjHdPbkvDbwYkmBE7UcdAwqqCuTObzl69YWpwayZfGZ/rkRFnz2KM3qa55IpZQmHWXwoF8u/PeU/WIL3ehXvnMAWWk6O1X4JBhyCPHs6H6HfUlVRtj29Aw5YEIcSea2eu4PCw1jASEpa4M9S4vphNduzg/WgqYqY+wYkk+3+7NmCudqKSwxE9qnCgHnGhGgDIi0jlubrv4ItLBvdeBf9LbXzFVMUm979RnJe7OtwTqa16BBvmYRXcaLWDkQtVlYG1rH2EbRgjLQl0Z6l1eXCe6Ui8HTdBHuU6U2cpdHep/5dtTWjjamKjjZ0cA1CufOaAMRZK4PThFF5AMWAzXFy+ur11cnxkrxrvdCta29hHOb0FYD+rKUO/yIjjRmbGe9ZwZK+Y3mhhDTnSplgsYE5UXll8nKhtSpXhpqA/qlc8cUIYisd0kbKgjaLqDxamReF0G1rb2EZXfgrDUlaHe5UUZE50d791MNKhNielEmYHxSqNRC5qdlxVmf0HZ4KewVKoHNVtKvfKZA8oQJRfdU8bYBRhC3R3Mj5aK5am1hGOiWNuaEKXfGnhhqStDvcuLfZ1ocNi+/Dz7UK985oAyAKSPpCPwxi+CpubDOFGsbU2Iym9BWOrKUO/y4EQJQ73ymQPKAJA+AbPzsW63grWtfUS5LmfghaWuDPUuD06UMNQrnzmgDADpo+sR4i5yxdrWPqK+GpLZOpDCUleGepcHJ0oY6pXPHFAmkM5/tG1nEYGQCff3e8U4Wl8SIPfrdJC4z41J+SRjoljb2i8i+a2BEpa6MtS7vGAnOjE9FzsWls8hEIioYe6Ez/nvlGnug0wgTVj8Rn03o6Z3CfxeJj7UBIK57MNj+bC2tY8sBPqtQRWWujJGe40UCMwfY6LuQr3ymQPKSMmeDZUWgA21RezOAl1GOqBhVEFdmcznDyfqLtQrnzmgjAjz/+vuwCG7XSzG/UkcaOSKcbuojhn4VrOX9HPFb6c6YIxvF5iVJs8w5VXZhlEj8CDpAyfqOGgYVVBXJvP5w4m6C/XKZw4oI4XzQ9y/mhc5wVx6f1U5xcBjSrPSbNcnrDm+PlXpMTWHUiUfMqVANaQHia1hysCJOg4aRhXUlcl8/nCi7kK98pkDykjR+xuVlwppyyK5wxhmNNCQRfJ2UY8pPVRs96lKTJ9tyNcWgRN1HDSMKqgrkybI6NcAABmLSURBVPn84UTdhXrlMweUkaL3MdIZXr3dCeNExWNKjxZoRmO7XmlKqt1VJaUH1Csm/jWGE9Xno/e46ZNkeSsWuSIQCFXbkgEn6tJdy/qK5mcbcKCMSOBwWqAtC3PAQCMbZiBWU0yfsDRP7q/hBzI1X1mVVaDXj5RtYObih9oFY6KOg4ZRBXVlMp8/70QXp0ZC3pUj8LnzDEaNIpzowAFlRDQmTDWMFzggF2bYTzym5q1mLzETlTnTH419oTqmeHxVttKvE/K767PVZ675UIvAiToOGkYV1JXJfP4+J7o4NZIfri/2o1lh75zVbFRMmlE40YEDyqSAI+6ng1PJDCxwoo6DhlEFdWUynz/rROdHQ9ydOIYT9T2RgLmfq/9pWcydYmUPgu15TX6jenffzWPpmVXqlc8cUMY0jjg/cXQTWARO1HHQMKqgrkzm82ec6Eq9XBope8/M2HiMWx+caO/RVp1HYPm3df1i943vMVqSwvIHasl2F54NS+3JGdQrnzmgjFHEWWa7mdjOAnSBE3UcNIwqqCuT+fwZJzo73rs2dKVeLhVHZ/vjRFnz2KM3qa55IpZQmHWXwoF8u/PeU/WIL3ehXvnMAWUASJ9BcqIkL/qy1DAS0Iq6MtS7vKhOdHym+3ZtcrhYnlpL4kR7yOfbvRlzpROVFJb4SY0T5YATzQhQBoD0UfUFM2PF/OZN+v6iL04UC2H1sA0jtGKhrgz1Li/y7PzGdaJ9cKIS38fPl2udqLRwtDFRx8+OAKhXPnNAGQDSR94XzI7nh8dHg/qLfjlRLITVwPktaOVBXRnqXV6kFUuM+2Rn6s040aVa0JiovLD8OlHZkCrFS0N9UK985oAysWGvvMRVmCASso5gbXK4ODobPHLRdyeKhbAiKr8FragrQ73Li3g/0ZV6udRdsaS/SDSmE2UGxiuNRi1odl5WmP0FZYOfwlKpHtRsKfXKZw4ok4Sce4+RBCQQe4HFqZH82HyYObT+O1EshBVQ+q2B14q6MtS7vMh3tg8fpC4/Jwn1ymcOKBMb2FAQG74XWKmXu0sLLDhRLIQVUfktaEVdGepdHpwoYahXPnNAGRXeBIBqC5woiI1sXl64ssuwE5XOcWEhbAflupyB14q6MtS7PDhRwlCvfOaAMlJEu6l50YYTBRHxdwHzoxuXcvVC+4i+fl8nymzFQth2u627GpLZOpBaUVeGepcHJ0oY6pXPHFBGRLSVge4TThREQt0dWFmxxGzFQth2ux3Rbw2UVtSVod7lBTvRiem52LGwfA6BQEQNE6e61Il2UBWDEwWRcNSJYiHsBguBfmtQtaKujKFeIzUC88eYqLtQr3zmgDIiYSbiYUNBEmJ3Fugy0gENowrqymQ+fzhRd6Fe+cwBZURUI6DsRtVrAMIAJ+o4aBhVUFcm8/nDiboL9cpnDigDQPrAiToOGkYV1JXJfP5wou5CvfKZA8oAkD5woo6DhlEFdWUynz+cqLtQr3zmgDIApE+S5a1Y5IpAIFRtC10n6tLNysyg+dkGHCgDQPpgTNRx0DCqoK5M5vNnnOjsOH+b4u6T3CI0K76nF5g1inCigwuUASB94EQdBw2jCurKZD5/5ZjozFgxPzYftVlhb5jVbFRMmlE40cEFygCQPnCijoOGUQV1ZTKfv8KJrtTLpZHJlcjNiv+escyDCJjbuPofksXcIFb2/Nee1+Q3qnf33TOWsFmlXvnMAWVIEP5GUTk/phMD8YATdRw0jCqoK5P5/OVONHBANJQT7T3RqvPkK/+2rl/svvE9PUtSWP4cLdnuwiNhXXoGRiSoVz5zQBmX0d8/X2U0cdd994ETdRw0jCqoK5P5/KVOdH60VBydjdOssE6UNY89epPqmgdhCYVZdykcyLc77z1VT/YiAPXKZw4o4yyBhjLkRphRB8mKE83slV2WGkYCelJXhnqXF8eJLk6N5Ifri7GaFd+KJfl8uzdjrnSiksISP6lxohxwolkDyoh489rsHDf7giuZ8z9sSfVW/AjuyNKPFj+UPUiYjXCiDiL0AmuTw8XeCtdY02geWO2aHLZhhJ4s1JWh3uXFcKKhBkRDzc6zW7mrQ/2vfHtKC0cbE3X8pAgL9cpnDigjhXOH7Ebpdu6F9K24nXvBmc6cYkw0J0PzoXCiDiJ1omE6i5BOFKtdE8L5LejpQV0Z6l1eZCe6ODWiv3lTQie6VMsFjInKC8uvE5UNqZK+NNQH9cpnDigjRertAjcGvpVuaauNb+BeYTbCiTpIak4Uq13jofJb0JO6MtS7vKhOdH60VCxPrcVuVlRXZTI/RaMWNDsvK8z+cLLBT2GpVA+ytpR65TMHlJGSC+FEO+j3DXwb/uMCPyj8xwHr6Gbng+61Es2JYrVrLJR+a+D1pK4M9S4v/v1EE/4HFySHeuUzB5QRCfSF0jJcycAd9Y4z0IZKt8OGUkHTHYSZTAvvRLHaNR4qvwU9qStDvcuDEyUM9cpnDigjwswCBFx/yZbRv1Xt1RZMp2dkuUNFSjvkLsAW2h4heIFBhBVLWO0aC+W6nIHXk7oy1Ls8OFHCUK985oAyIvBwwDS6HiHuw1A8sNo1OeqrIZmtA6kndWWod3lwooShXvnMAWUASB+uC5gZ61nPmbFi4L3/EjpRrHYNJJLfGig9qStDvcsLdqIT03OxY2H5HAKBiBomTnWMiQLT8OZydrx3M9G4t6D2wGrX5CwE+q1B1ZO6MoZ6jdQIzB9jou5CvfKZA8oAkD6xOwt0GemAhlEFdWUynz+cqLtQr3zmgDIApA+cqOOgYVRBXZnM5w8n6i7UK585oAwA6QMn6jhoGFVQVybz+cOJugv1ymcOKEOOztVQ4mtpAcdxLdXU8oETdRw0jCqoK5P5/OFE3YV65TMHlKFCTn0LUn3hqAdPeKioGD1+yIMH6tl3kixvxSJXBAKhbM3gRJ1F87MNOFCGHGnaUNMMpg1tY0zUedAwqqCuTObz9ztR5q4cgU+fR7NiGuqVzxxQRop3S5B2m3/uEWdWxI2BWzTH8V6Ln8uWlL7mNoZJjN3IfWUxJVVWmhdhPlfMXypLmINwX0HzV+nXZ/UM8xWSACfqOGgYVVBXJvP5s050ftR7SEbiB2aA5FCvfOaAMlKkfoX7k2pj+BeqD9XvonodmK1qF43lEv/EvQjzJ/FFoBRhvk7gV5MKFfj1uX/1+8YGTtRx0DCqoK5M5vNnnOhKvVwanxFdKZoVS1CvfOaAMioCzZ/KwUgPojFJ4kHEo0V1oqrEQpbX/yn8i3hOOkx6kcSJ9PXDfIXkwIk6DhpGFdSVyXz+vtn5mbFivjQ+c3FtcriI2XnrUK985oAyGkKaTql3ZP8UaICkx4nnRKVWUpOG/oDJnSj3uSrbpyGk+Po8Y3z9MNLFBk7UcdAwqqCuTObz51cszYwV+/LoNpAc6pXPHFBGRDUqJv6pHWUqPHCMTXpMVQLSIwRmK+5lzoZKj6D6jipiix9StMBigYLHIytO1P8MxgxhqWEkoCd1Zah3eVGvEy2Ozq6vXVxfnBrJY3beNtQrnzmgjAg3DJZjkJbhXoheR3o06edyL9hd9K81n6j/XKmZ0/xJ/PRAg6h6qzmCmHZU8TW7hPn6IX+y2Eg7gsWpke4612Rdhvcg71wulzNrbAg4p3iwDSP0ZKGuDPUuL4ITXZwaYYZCgyfo4URNQ73ymQPKBNJfCwIikVXx5TY0xARaSCdaaTQ7r5uNikmLQMA5xYPzW9DTg7oy1Lu8KGOis+N5b8XSSr28MT4KJ2oL6pXPHFBGT1adEAkyLL7QCwQvbI3nRDvjVt0uvNmo8ONXnQ7eG9ti9pMUFjeqd2eLum6uJKj8FvSkrgz1Li/6iiXcT9QZqFc+c0AZDV7zZjuRQSTb4vO9wEq9XBopD2/0GmPzfXOizUal+26ptrG1t63bi3ffMFZCWnip1rMAnQKq3X2vmSOQQem3Bl5P6spQ7/Iir1gKH3CipqFe+cwBZQBIH74XmB3P+25BnWgajfUHbJfeozfV6Z/09I9x8YXZPl84kG933hFIj+s0Kr8FPakrQ73LgxMlDPXKZw4oA0D6yJyodwvqpEsLfOtI5LOg3jym0h9ICkt6eY0/4KDtRKGnB3VlqHd5cKKEoV75zAFlAEgf6ez8xnWifXCikt6Yn8XU+gNp4WgjVfSuDWVRXw3JbB1IPakrQ73LgxMlDPXKZw4ok4TO/8FtZ5ESCb+suLt16Sz+fEIvwLhPdqbejBNdqgWNVMkLy6/ekw10Ubw01EckvzVQelJXhnqXF+xEJ6bnYsfC8jkEAhE10jn5dae9MStj3aiJJEwp579hZ8qfntoxwyDxlyv1cqm7Ykl/kWhMJ8rMpVYajVrQnKmsMDsZKhuSEhawODCZHJOFQL81qHpSV8aFXiMJgfljTNRdqFc+c0CZJDhoFs3RRxsa42hZsqHt7DxjKbOgYVRBXZnM5w8n6i7UK585oIwK7//Y+i3sn7jt3kbNC3FfzV/FkprcxH2leUqPLz2O9CtoSgbqpvlq0sSkW/qVUsrAiToOGkYV1JXJfP5wou5CvfKZA8pI4Qxc22/O9Bu5AqJbYstInZ/0aJqS0nwCv4gmYalB7ONG/VcLL3W/UkofOFHHQcOogroymc8fTtRdqFc+c0AZEb0vbAfZI2mBqJaIO1r4ktK/qnyw/hsFfqm+bJRac81eMcQPs1fKwIk6DhpGFdSVyXz+cKLuQr3ymQPKiMRwokksaeAnakqqXJ24MYYTDeOGRfsoul7VxsBDSRPLbRD+OPqUrJBkeSsWuSIQCFXbAifqLpqfbcCBMiIhXaNqYxj32RcbqvrcMAUCv1Hgl1J9r5Abw+QQcq+EKVkBY6KOg4ZRBXVlMp+/34nOjnefIBx0Zzg0KylAvfKZA8qIqEbdRDMnHagTR+BEA6QfnNNYN01WUnelcpmqbxR48BxDyJLSz9J8Nb3UYoEkKbUtASfqOGgYVVBXJvP5M06UvTWx7zFuaFbsQL3ymQPKgEhYdG8qHEwpEDhRx0HDqIK6MpnPv+dEF6dG8sP1xe7b+dFkD8wAyaFe+cwBZUB4HPR8DqYUBjhRx0HDqIK6MpnPnxsT9cZB50dLRf0zM9CsmIZ65TMHlAEhkc6w28XBlEICJ+o4aBhVUFcm8/n7rhOdGSt614mWh+FELUO98pkDygCQPsSdqP/Ri1nEUsNIQFjqylDv8iKuWOoFxkTtQ73ymQPKAJA+fC/grXD1Qru6QNpleM/vzuVyObN+hoBhSgjbMEJYFurKUO/y4jpRrFhyAOqVzxxQBoD00Q95zowV82PzUbuMpVqu0mh2XjcbFZPOgIBhSgjntyCsB3VlqHd58Zzo/GipWJ5ac3uqJftQr3zmgDJ9JLVrFpN8kGsXVjqST8pp6HqElXo51iJX1hZ0hqu6PXezUeGHrTr9ujekxewnKSxuVO/OFnXdU+lQ+S0IS10Z6l1eFCe6Ui+XuteJBtpQONEUoF75zAFl+ktqbibJB+n3Td8XSj8xNU+f8id2SDIgGsqJNhuV7rul2sbW3rZu5919wzgIaeGlWq/n7xRQ7e57zRyBHkq/NfDCUleGepcX+zrR4IATNQ31ymcOKNNHYENjMIA2tK1zosHrCsI4UbYn79Gb4fTPdfqHtvjCbFcvHMi3O28EpMelgcpvQVjqylDv8uBECUO98pkDymjwpnza/tlb9rVYUnMQ6RbuI7iPkx5WLB/p4wL35XJTuTTNF4maT+w0Ao8f8suK3yKMArFR9QX+e1FHdqI95JOfuVyQLZAUlnTuGlvAkREnCmE9qCtDvcuDEyUM9cpnDigjhTUfOcHDtRXGJaewjNIXgQfRH1ZaLMxBuPxVCWte67+R6guG/3bx0ojxQeKRxR9Xk2QSkgyIhpqdZ7dyl+r5X/n2lBaONkBF+NpQFvXVkMzWgRSWujLUuzw4UcJQr3zmgDJSYvjFttoVBRbQuLfwRk3lq8R9Ob8YmFLIzFWJhUk1XhqqwvH8rkr5vtvQtsKJLk6NBN5oJYkTXarlAgao5IXlF+3JxrdIXxrqI5LfGihhqStDvcsLdqIT03OxY2H5HAKBiBomTnW9QWFfa4YD21orxr2N5ESlB5FmorFfyZ2o1M4GOtEwKoVPg9suHj+k7Za+1u+bENWAaJgVrtGcKDOFWmk0akFTpbLC7ByobCRKWLfSwxH3FJ2FQL81qMJSV8ZQr5EagfljTNRdqFc+c0AZEdYGSS2RuFFvy0IeRHytd2mBmQS+yKl9nup1YA5hPl2VQOw0xKOptoT/FP1HJyR2Z4EuIx3QMKqgrkzm84cTdRfqlc8cUEbE+9+197qtHnQUS0qPo9nI/Hc+1Pif/iCq9MRjSo2d6piBOUhfBH596fHDp6HXQb+7NHlxu0aBJMCJOg4aRhXUlcl8/nCi7kK98pkDylhH5bHSzwSkBpyo46BhVEFdmcznDyfqLtQrnzmgjF2kY3XS7SBLwIk6DhpGFdSVyXz+cKLuQr3ymQPKWEQzf20rJZAOSZa3YpErAoFQtS1wou6i+dkGHCgDQPpgTNRx0DCqoK5M5vPvOtHFqRH+cfPMY+ildy1Gs2Ia6pXPHFAGgPSBE3UcNIwqqCuT+fxzGzeEm58cZm8Lx9wlbnY8XxqZXEGzkjbUK585oAwA6QMn6jhoGFVQVybz+Xuz82s+Jzo7zjw2Y21yWPIwNzQrpqFe+cwBZcyBKz6BCjhRx0HDqIK6Mr78X9sSP1zIX4bciS5OjeSH64tSk4pmJS2onzzmgDJG0d+/EwwscKKOg4ZRBXVleCcaD+JOdH1mDE7UAtRPHnNAGXPAhgIVcKKOg4ZRBXVl4EQxJmoN6iePOaCMCPuMIm6j9Ok74kN9xBfmntYDKCLxl7PjnVWt/IJXOFEboGFUQV2ZQCcaqrkm50RxnagLUD95zAFlpIi+U/VCfKt6hqS5bAE5BHM5P+otZl2pl2ULW9FlpAkaRhXUlZE60ZyfdjsnbPM34PSc6MX50dKG+/S5UjQr6UH95DEHlJES6CxVZVTl4UQBC28uV+rlXtfAuFI4UUugYVRBXRnRieZyub0bdGyo50eFP/l2tELYuzh5Myy9SRbvfqKK9gXNimmonzzmgDJSNPPyYrFAS9qGEwV+xF5gZqyYL43PKK7gQpeRMmgYVVBXRuNEO6303r172X+5v7I7WiH8mCguP3cO6iePOaCMSODYJzfqyV0PqtoLAA9pRzAzVsxv3sSucEWXYQs0jCqoK6N3olLgREF/oH7ymAPKiIjGUbxsVPVWfMG9BqAtv060exHX4tSIavYMXUZqoGFUQV0Z/ey8BjhRkBTqJ485oAwA6cN1AWFusYIuI03QMKqgrkwYJ5rL/VQWcKIgGdRPHnNAGQDSh+8F2MWsK/VySXKLFXQZaYKGUQV1ZUI6UW6vjhnldrRCsBOdmJ6LHQvL5xAIRNRI5+QHoL8oLxLF/UTdAG2LCurKLMR1ot6/3o5WCNQfY6LuQv3kMQeUASB9YncW6DLSAQ2jCurKhHei3rw8+7prRuFEQQyonzzmgDIApA+cqOOgYVRBXZl4Y6IecKIgPtRPHnNAGQDSB07UcdAwqqCuTIwxUW5w1NvRCnCihKF+8pgDygCQPnCijoOGUQV1ZUQn2haf7IkxUWAC6iePOaAMAOmTZHkrFrkiEH0JlaFU3MXJd52o/eQVwIm6i+ZnG3CgDADpgzFRx0HDqIK6MguyMdHIuD8mujg1It6GQ7oRzUpqUD95zAFlAEgfOFHHQcOogroyg+BE50dLxfLUvP8JGdKNaFZShfrJYw4oA0D6wIk6DhpGFdSV4Z1o7HAhfxne7Lz0WW26B7ihWTEN9ZPHHFAGgPSBE3UcNIwqqCuT+fzhRN2FeuUzB5QBIH3gRB0HDaMK6spkPn84UXehXvnMAWUASB84UcdBw6iCujKZzx9O1F2oVz5zQBkA0kfSEcyOd587XxqZXIETtQwaRhXUlcl8/nCi7kK98pkDygCQPhIb6hnQ2fF8aXwGTtQqaBhVUFcm8/nDiboL9cpnDigDQPpwXcDi1Eh+uL7YfTs/GjQsii7DNGgYVVBXJvP5d+/i1J1h2bxp4wai0o1oVlKFeuUzB5QBIH1kY6LeOOj8aKk4OgsnahM0jCqoK5P5/PGMJXehXvnMAWUASB+xF5gZK3rXiZaH4UQtg4ZRBXVlMp8/nKi7UK985oAyAKSPtkfAmKh90DCqoK5M5vOHE3UX6pXPHFAGgPTR9QhYseQAaBhVUFcm8/nDiboL9cpnDigDQProB0RVa1vRZaQGGkYV1JXJfP65iem52LGwfA6BQESNdE5+APoLby5X6uWNha2BNhRONAXQtqigrkzm88eYqLtQr3zmgDIApE/szgJdRjqgYVRBXZnM5w8n6i7UK585oAwA6QMn6jhoGFVQVybz+cOJugv1ymcOKANA+sCJOg4aRhXUlcl8/nCi7kK98pkDygCQPnCijoOGUQV1ZTKfP5you1CvfOaAMgCkT5LlrVjkikAgVG0LnKi7aH62AQfKAJA+GBN1HDSMKqgrk/n8u050cWqEuxNHZ0snpE/OQLNiGuqVzxxQBoD0gRN1HDSMKqgrk/n8cxs3JZ6fHGZuTbxSLw/XFz1LKnt4BpoV01CvfOaAMgCkD5yo46BhVEFdmczn783Or/mcKBsr9XJpZHIFzUraUK985oAyAKQPnKjjoGFUQV2ZzOf//wF4XxPIo5z/vgAAAABJRU5ErkJggg==)
Simple.. isnt it????
=TRIM(A1) where A1 represent corresponding column name.
Simple.. isnt it????
No comments:
Post a Comment