If you need to separate some texts that are in a single Excel cell, what is the solution? Copy & Paste! simple! But if you need to do it for hundreds of cells? It’ll be a nightmare! Don’t panic, there is a solution.
Let’s check the following peoples’ name. Their ID is attached to it.
01 Hasan
02 Kamal
03 Jamal
We can separate them easily typing following formula:
For ID: =LEFT(C5,2)
For Name: =RIGHT(C5,5)
But this ID & Names lengths are same. What, if they had a different length? I’ll show you in the next part. Stay tuned!
0