Combining two or more column in an excel can simply done using the formula
=concatenate(a1,b1)
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAbIAAAD2CAIAAAA8r5WFAAAbpUlEQVR4nO2d23sUVbrG+++Yf6Dnbu76rnke+srLefZN9mbrVh5PYxhPgYSMs0eH7cx2dIyjo22z7YBHNOIocjDEFiMEITIBEkJDIJwMCRE6iZACE0TnWfuik+pVh6+7q1O11le93t/zXZDqOizeVd/bq6q6vpX4zYs7EAgEAmFHQoBm5Ls56/ltB/64dd/uQ6fPTMycmZjR3aII+c2LO3Q3ATQVsMUmpO/I2Y7c3oET396+8y877vzUtAFbBOECW2w2Xvrw4N8+PDQ9e/Pmwk9y/HD752YN2CIIF9hiU9F35OxLPV/P3bzjjRu3YhnnL105Onyq+jqwRRAusMXm4bs5q/31vee/s67e+NEbM/Pxiw2dz9z9Xw/dc9/DT2/6S5XVYIsgXGCLTcKdn35+ftuB3iPnp2YXfWN6LmaRfeOdljVrT5278mT7f//5+VeqrAlbDIVSoa2tUFJ7zGI+ofyYdRA3WywV2hLLSHqWF3MUWBVnL888vXXfpasLclyYtgr7hz74x56t7+wo7D96YdqaKC3EJe57oLX1sY561mzEFokTybHc+Ukx77duvlh7n8vbSuuWF7jIF12HX95N7UOv+BC+DuXZp+M/SqSba/+Orb0b6vDi2sTKFot5WdJlQctLi4U2o23xo69Gt+0rjl+5ZceZSWvg8NG+Lw5+sqvwXs/O/Fvb39z26ZmJ6+enbzGP9Z2bWtasLceaex6ouX5gW/Q/kZZsoJLHpUKbtF4xn2hra3N/bv9F7XN503zebWTLu6hud3UcOoxDEK7o3WfNdJOPVypUWk1syHK8GCNbLOb9vriWcXe+abz04cEvRyaLly07To1fPjZSHDg0JDvjrsLg2ORN/vHXv29pWbM2u6WnnpUD2iJ1IvmdQtK6xfxSVtsbSwZT9eQsZ76vHdVvi+ShQzuEe2mVfVZLN8dHnvW8G3L0xfjYIvElJ3/MTt0w8LkSSvj02u/znw+cujZ8ad6Oi5enx85ecDnje9t7Ry/N84/H2//QsmbtP89cG700f+DYxd39x0YvzQ8cu7j3wAnvyqQteq8jyTynzqBK0i79S1qtsqeqJ+fyLvwOEMAWiUOHcwifDavts15b9K7mv6RKYmshPrZYfbDYvLYoPM7ou05Hbu/AydLQuRt2TF+bnZh0O+P2T784dv4G/7j73ofve+DRY+dv/PbJp+69f93Lm99/Nf/hg63r2zo3eVcONlqsNlisNoqyDdK+XK5sUeXkdHmZ6xz18yzvjblqhw7nEJ7/QPV91rJFn1uX9IYMh4uwxXhQ3ROFEM9vO/DZkcnDY9ftuHxtvjQz53LGzw+OfnP2OvP4/JtzLWvWtnX+6Zuz13u/PvPMc6+1rFl77wO/pdYPzxbrGC0u78Ix7qRPzuqXlMFGi76HDucQ7v9AjX3WfRHtuuUKWwwd0+8tVvFEIUT3nqG3CqcPFOfsOHhq7vsbN2VnPDA4MnCydPDUHPN4/rV3W9as/evr28p/Ptn5bMuatb/b1NV7+Lzv+sEuoskTyW+5+96inO35Qu17i+7Hvu7hU2Bb9B46lEO42l9rn/Xbot+eYYth4nww6HrY1/y2WJ2hsck/vrn/ixMzcnx1cmbi6o0rV2cvTFw5Upz88kSpf3SWfzyx8dm77324f3T2gdb1jzz+u1ff2rX2wcfX3PPg2oce910/6JNo6kRyLfd5Eu3+SZjzGYh3n+6xkuPR7PLfAW3RdehwDlF9iOfZp2enkvkFHS3i3uKKcXyLyb+qoG9mGMLC7Tudm/t6DlzqPVbyjc+PxyD+/T/vz71fuOe+R/788tufHy99vP9MPVs18LtFvxNJCOE6m6r+kqS8C2qIZf92rMr4U9S88Ve5pUgdOsRD2NtU3ad/urlsUUbeq1+eMhwsxs0WQRWGxibbNxd2DE7vOnLVG3uGrvGP9qdffKzjT5v+9lagrfCWSwisxJ1WMuCr8cxAD7DFpqJ7z9BfPjjy8eHvvLFjsGkDthgGjftiaQVvqrB0RdhiczF/a7Ejt/eF7Ud7Dk67YvvXTRuwxVBYibs1CscraAFbbD7mby2++vHhDbkv/m/vuXe+mrJj2/6mDdgiCBfYYnNyuDix/rXPNr0z+PddY1v2TW7ZN/nWl00bsEUQLgnts8kgEAgEq8BoEQAAHCTGphcRCAQCYQdsEYFAIByBe4sIBALhiMTW3uMNx48//wsRXUBhKqxs6sezbyIMDyubiugES5yashqIT4cXt/YeX7jzEyK6gMJUWNnU7bE8wvCwsqmITrDEh19fayDKtnjr9h1EdAGFqbCyqduncwjDw8qmIjrBVmSL1sKPiOgCCpORTS2eeg1heFjZVEQn2Ips8cat24joAgpTYWVTiydfRhgeVjYV0QkWwBa/OXvDZYvf31xERBdQmAorm1oY7UIYHlY2FdEJVq8tHj5z/cc7P7lscXZ+IS5x6I10cvWqV4b0t6T+4KHw5Ccb08nVq5Yi031If5MWrGxq4cTz5sbAurbMcqesWzepvT2awsqmIjrh67LFQ2PfLyzeXli87bLF0vUfYhLHX85sfHnzxuTmGLX5Bx4KT368Mf3o7kn73xw0tLKpheH/NTR23JPM/Pqz/Ut/Tnb/uq37D/pbpSOsbCqiE762LX59as66uVAOly1enbsVj/jmjWRH7+lzvesybwxob0zdwUPhiY860ut2TZT/PL1rY7Kj97TuVlnZ1A/H/8fIeCKXSec+0d4MFmFlUxGd8DVscaA4+/31m3a4bHF65mYsYn8u3frpxPTMxPb28j/0N6me4KGwLBoXAa1s6odjz5gY/Q8+kVlzTHszeISVTUV0wlezxQMnZ0qzN+Rw2eJkaT4GcXbPI5mOD87OT5bmT+zoSLbvOaG9SfUFD4UvfdAu31tcUlJvWNnUraHfmxj/aElmWoa0N4NHWNlURCc8aYtfnShNX5tzhcsWJ67e4B/Dn7QnN+weLv85tvuRTPv7Y/pbVU/wUPji+xvSj3xycenPg5uTDAS0sqlb/+w0MT5qSWZahrQ3g0dY2VREJ7y/LfaPXLt8peQNly1emr7OPi68t0Ea7KxelVy96uGPL+huVV3BQ+EL721IS4odeSGTfmFAc6usbOrmkQ1GxkOvZ9Kvb9feDBZhZVMRnfA+tvjl8NVLl/3DZYsXpr7nHvtzyUz7uycrS45+1J7M5Pq0N6yO4KHw+XfXpx/66Dylp5awsqmbg0+aGd/m7kpm7trd12b/+URunfZWaQkrm4rohHfb4hfHvjt38QoVLls8d3mOeex9JZ18ZdC5cPC5TPq5r/S3rWbwUPjc2+sdw20O0lnZ1M3Djxob3+buqvTIw//xre726Aorm4rohHfYYuHo9Nj45SrhssWzE7OI6AIKU2FlU9ahVoTpkU1FdIKt6J3osUsziOgCClNhZVPWwYcQpkc2FdEJtiJbPHWhhIguoDAVVjY1P3A/wvCwsqmITrDEp8OLjcXW3uMnz11DRBdQmAorm5o/cC/C8LCyqYhOsISVTTUWK5ntAIFYSTR80iKaLCI6wRLiVFdjYWVTumdzbXJGxq7obgJHEonEr375iwQwnvJpEMk5BltkC2zRl0jzAcQF2KKhwBZ9gS0CAVs0FtiiL7BFIGCLxgJb9AW2CARs0aaYTyTyRcUH1Yh6W4yFwlpskY8yfFqiF6W2OPP2vyVXr2p/+9lgtljM24+Housy004Ihy1yUrhUaEskEm2FUlTtqIo7H/gow6cluvtIAcps8aktmXT720/teywdzBZLhbZKTxXzkXWFubbISOFiPpFoKxQLbTxskY8yfFrCoI8UoPgi+tmGbNFP//IXluPLs1RoayuU7G/VfLGykr0H1zqVPTtPCGnvTWqWTltkpTDVIBV4bJGHMnxaIn0EW2xw5yHYov+AvfKFKfVPec1y/y31aOUPxzryH0v9LZ8Q8r+btf+li2huCrOxRUbK8GkJsaC54G+LQlTuq1BfmJV+t7/UHH9UetixWIhifnmfzlXkA1XWaSZcj1w4KczHFoXgpAyflsAWV7TzsGyxTKnQ5vyKc43wGzshlv50ruKiCU8A3yfRPBTmZYuVNulXhk9LYIsr2Hm4tljpTvf4PvTvyea8nyhD/ECHg8IcbZGHMnxaAltcwc5Xbovlm8NL+ys/BCs5TohiPvD3pOPLdnnv0i6bvMvL2LbIT2EutshHGT4tkVrUzDmizBaf2pJxzNpR3Rw9j1zcw3jpKVohH/h7Un5O51nFfdCmvIb2PnLhoLD02zxNwid8HrlwUIZPS/T3kQIShr3lYsYVch1E9pZLvBWOMh/4KMOnJUyBLRoKbNEX2CIoE93bsbBFvsAWfYEtgvLNAbsacfj752eLYAlU0PFFzgdgIEKBLa5kIoWRsSsIhOL41S9/gTA5vOdA6OdYYmp2sbHY2ns8dJMGMiMYLfqRwGjRbISC0SJskS2wRQooYziwRXNB8lNAGSAifRINW2QLkp8CygABWzQTJD8FlAECtihh0O+5NCV/DBSGMh44ty0qFNni6M5O+4XorsEAtuh8CTPS3jGo++VeZ66wo7BB9MRFGc5tE8p7LXSU2OJ4X2tH36jtj5nu/iC2KFdbj/IMMNcWuSqsYeaQmCjDuW3NMN+L8ovo8b7WTGfPeCO26Cl95PqudJUGkbbzWdm7kN7cUU2kGZyTSn6WCistYxUXZTi3zf4ItuiFsMXB7oZHi5LUVSay8NTU9F/ZLlxnr0Bt3oSzu5DJz1FhHrbITBnObfNfECsU2+JUT0e6dedUoHuLtrhyj1WojPGdo/2i3yws9irO2nKiyubu/vXdb8ygkp+lwixskZsynNtmbxXfPFFqi/25dHL5JmMjj1z8h//2AJ7sfp+VfU6OKt3vIr7dvQT5YIGjwjptka0ynNtmbxXfPFFni3V6YtV7i9JS150T578cW/quHOxbsRnuJ8rQd9CkpVwUZjFaFPJSBspwbpu9FWzRi2yLUz0d9XpiUFssEhNZ+Ha/tLL/PRS/L9V4d7AvgZJft8J8bVGjMpzbJmp/yh0ltjjYLU/kkly9KpkbXpEtShcR1EQW8pZ+K8tXAX5ff5572v7XCvGkdvKzUNhxpahG+Jgow7ltGnotdPCWi4ngFTcKKAMEbNFMkPwUUAYI2KKZIPkpoAwQsEUzQfJTQBkgIrXFrb3HGw7t03ogEAhE6IHRIl9GMCYigDJA4CLaTJD8FFAGCNiimSD5KaAMELBFM0HyU0AZIGCLZoLkp4AyQMAWJZqxJgSBpuSPgcJQxgPntkWFIluszOVSqwbtFOZyiZ4R55u/nBV2FEGNnrgow7ltQnmvhY4aWxzuWi6f059LV68T4bVFW9xSgdWcFTHGlfxcFS5iLhcKxm3T0Guho/oienRnZ80KY5jLJWqo5GepMJPCYryU4dw2+yPYohdfWxzuyjQ+aYEkNZ85K2IJmfwcFeZhi8yU4dw2/wWxQpUt2iUXa11BV7FFuccq1KxC7LtysCrE8o6oSndxgkp+lgqzsEVuynBum71VfPNEx0V0wJn/KvgP/+0BPNn9Piv7nBxVut9FfLt7CfLBAkeFddoiW2U4t83eKr55ovwHOiuaJ1pa6rpz4vyXY0vflYN9KzbD/UQZ+g6atJSLwixGi0JeykAZzm2zt4Itekk4rHD52rmB0WL17i9iLpfgBEp+3QrztUWNynBum6j9KXfUjBanejrSy79brDFUrMsWpYsIzOXSALWTn4XCjitFNcLHRBnObdPQa6GDt1xMBK+4UUAZIGCLZoLkp4AyQMAWzQTJTwFlgIAtmgmSnwLKAIG5XBAIBEJZYLTIlxGMiQigDBC4iDYTJD8FlAECtmgmSH4KKAMEbNFMkPwUUAYI2KKZIPkpoAwQsEWJZqwJQaAp+WOgMJTxwLltUaHUFvtz6eTqVUHL0EpE2jsGdf+I881fzgo7iqBGT1yU4dw2obzXQkehLQ52Jzu6uzoar85dKrCasyLGuJKfq8JFzOVCwbhtGnotdJTZ4lRPR7prcKpnBbboqIUkFe9wFo2TyoL4FeesdLB7Ib25o1JIMzgnlfwsFWZSWIyXMpzbZn8EW/TimRA1N1w2R8zloh0y+TkqzMMWmSnDuW3+C2KFElsc72tdKj27IluUe6xCzSrEvisHq0Is74iqdBcnqORnqTALW+SmDOe22VvFN08U2GL58rny78YfufgP/+0BPNn9Piv7nBxVut9FfLt7CfLBAkeFddoiW2U4t83eKr55osAWh7syy6W57ag6VTTmcoka+g6atJSLwixGi0JeykAZzm2zt4ItevH93eIKH7lISys3SGp9K/qv7H8Pxe9LNd4d7Eug5NetMF9b1KgM57aJ2p9yJ562KF1EYC6XBqid/CwUdlwpqhE+JspwbpuGXgsdvOViInjFjQLKAAFbNBMkPwWUAQK2aCZIfgooAwRs0UyQ/BRQBgjM5YJAIBDKAqNFvoxgTEQAZYDARbSZIPkpoAwQsEUzQfJTQBkgYItmguSngDJAwBbNBMlPAWWAgC1KNGNNCAJNyR8DhaGMB85tiwo1tjjV0yEV0ckN12+LzhcsI+0dg7p/xPnmL2eFHUVQoycuynBum1Dea6GjzhaXSy4GGy3Kb6aXCqzmrIgxruTnqnARc7lQMG6bhl4LnTjZoqMWklS8w1k0TioL4lecs9LB7oX05o5KIc3gnFTys1SYSWExXspwbpv9EWzRC3ERnensGW/UFitS85mzIpaQyc9RYR62yEwZzm3zXxArVD9yGd3ZmVya1yWwLco9VqFmFWLflYNVIZZ3RFW6ixNU8rNUmIUtclOGc9vsreKbJ+qfRA93ZWpcUGMul6ghHyxwVFinLbJVhnPb7K3imyfKbXG8r7XWdTTmcoka+g6atJSLwixGi0JeykAZzm2zt4IteqnYYn+u4oP9uXT1+a2C2mIRc7kEJ1Dy61aYry1qVIZz20TtT7mjZLQ42F3nnH/12qJ0EYG5XBqgdvKzUNhxpahG+Jgow7ltGnotdPCWi4ngFTcKKAMEbNFMkPwUUAYI2KKZIPkpoAwQsEUzQfJTQBkgMJcLAoFAKAuMFvkygjERAZQBAhfRZoLkp4AyQMAWzQTJTwFlgIAtmgmSnwLKAAFbNBMkPwWUAQK2KNGMNSEINCV/DBSGMh44ty0q1Nni6M7OOivRYi6XqBlxvvnLWWFHEdToiYsynNsmlPda6CiyxdGdnfUUifC1RVvcUoHVnBUxxpX8XBUuYi4XCsZt09BroaPGFoe76piroKYtOmohScU7nEXjpLIgfsU5Kx3sXkhv7qgU0gzOSSU/S4WZFBbjpQznttkfwRa9SLY43tea6Wy1p3MJOCGqs47Rcq04ucKwVAAOc7nUA5n8HBXmYYvMlOHcNv8FsUKJLQ52V+4njve1Bpy0wBZX7rEKNasQ+64crAqxvCOq0l2coJKfpcIsbJGbMpzbZm8V3zxRZov2tFZTPR3p1p1TjTxy8R/+2wN4svt9VvY5Oap0v4v4dvcS5IMFjgrrtEW2ynBum71VfPNE3UX08r3FwLboI657+F5vcfZGvxWb4X6iDH0HTVrKRWEWo0UhL2WgDOe22VvBFr2454leskL5gjoMWyxiLpfgBEp+3QrztUWNynBum6j9KXdU/W5xvK81s/TIpfqNxbpsUbqIwFwuDVA7+Vko7LhSVCN8TJTh3DYNvRY6eMvFRPCKGwWUAQK2aCZIfgooAwRs0UyQ/BRQBgjYopkg+SmgDBCYywWBQCCUBUaLfBnBmIgAygCBi2gzQfJTQBkgYItmguSngDJAwBbNBMlPAWWAgC2aCZKfAsoAAVuUaMaaEASakj8GCkMZD5zbFhVKbHGwe6kArR2VOmM1bNH5gmWkvWNQ94843/zlrLCjCGr0xEUZzm0TynstdDSMFvtz6eoFujGXS9S4kp+rwkXM5ULBuG0aei10lNuio/ZiMFt01EKSinc4i8ZJZUH8inNWOti9kN7cUSmkGZyTSn6WCjMpLMZLGc5tsz+CLXrxt8WaQ8VqtliRms+cFbGETH6OCvOwRWbKcG6b/4JYodgWh7tqTeRSxRblHqtQswqx78rBqhDLO6Iq3cUJKvlZKszCFrkpw7lt9lbxzROltljnbNGYyyVqyAcLHBXWaYtsleHcNnur+OaJSlusa6hY9d6itNR158T5L8eWvisH+1ZshvuJMvQdNGkpF4VZjBaFvJSBMpzbZm8FW/TitsXRnZ3Vf5fTmC0WMZdLcAIlv26F+dqiRmU4t03U/pQ7ymxxuCtTY8K/ALYoXURgLpcGqJ38LBR2XCmqET4mynBum4ZeCx285WIieMWNAsoAAVs0EyQ/BZQBArZoJkh+CigDBGzRTJD8FFAGCMzlgkAgEMoCo0W+jGBMRABlgMBFtJkg+SmgDBCwRTNB8lNAGSBgi2aC5KeAMkDAFs0EyU8BZYCALZoJkp8CygChzhal6VxqvhkNW4waJD8FlAFClS0Od9kTFQSctABEAZKfAsoAocgWx/taKyXFJIuELWoCyU8BZYBQdhHdn0snM939s1M9HbXLi8EWowbJTwFlgFD5yKU/l06uXhV00gIQBUh+CigDhMJ7i0vTFYzu7EziIlo3SH4KKAOEGlt0zmxV+zoathg1SH4KKAOEotHiYHdlFpfxvtZaE13BFqMGyU8BZYBQ+sgFv1tkA5KfAsoAgbdczATJTwFlgIAtmgmSnwLKAAFbNBMkPwWUAQK2aCZIfgooAwTmckEgEAhlgdEiX0YwJiKAMkDgItpMkPwUUAYI2KKZIPkpoAwQsEUzQfJTQBkgYItmguSngDJAwBbNBMlPAWWA0DCXS62qYrBFBSD5KaAMEAor6Cy7oVxNB7aoCSQ/BZQBQke9Rczloh8kPwWUAUJDvUWpUjdsURdIfgooA4SGeouZztYO2KJmkPwUUAYIHU+iMVrUD5KfAsoAocEW8ciFAUh+CigDhHJbHO7KYJ5o/SD5KaAMEIpscbyvNZOucyIX2KICkPwUUAYIvOViJkh+CigDBGzRTJD8FFAGCNiimSD5KaAMELBFM0HyU0AZIDCXCwKBQCgLjBb5MoIxEQGUAQIX0WaC5KeAMkDAFs0EyU8BZYCALZoJkp8CygABWzQTJD8FlAECtmgmSH4KKAOEAlsc3dnpfhVaekXat8IYbDFqkPwUUAaIiG2xXC9nuKdDrpojFdGR53iBLSoEyU8BZYBQchE95bBFR73FqR6/St2wxahB8lNAGSDU26JzuiunY8IWVYHkp4AyQOi2xcX+HGxRA0h+CigDhG5bxGhRD0h+CigDBO4tmgmSnwLKAKHBFuWZ/4jprmCLUYPkp4AyQCj4gc7S9NDyRC727xb9fp0DW1QAkp8CygCBt1zMBMlPAWWAgC2aCZKfAsoAAVs0EyQ/BZQBArZoJkh+CigDBOZyQSAQCGXx/6t/Hlxk0OaDAAAAAElFTkSuQmCC)
..........................................................................................................................................
Suppose you need to add space between, use like below
=concatenate(a1," ",b1)
............................................................................................................................................
In between "", you can use any characters, symbols, etc..
=concatenate(a1," sachi ",b1)
............................................................................................................................................
Suppose you need to concatenate more,simply use logic and do..
=concatenate(a1,b1,c1," ",d1,"/",e1) would look like a1b1c1 d1/e1
Hope you got it..
=concatenate(a1,b1)
..........................................................................................................................................
Suppose you need to add space between, use like below
=concatenate(a1," ",b1)
............................................................................................................................................
In between "", you can use any characters, symbols, etc..
=concatenate(a1," sachi ",b1)
............................................................................................................................................
Suppose you need to concatenate more,simply use logic and do..
=concatenate(a1,b1,c1," ",d1,"/",e1) would look like a1b1c1 d1/e1
Hope you got it..
No comments:
Post a Comment