Forum Discussion
Split cells
Hello Everyone, Suppose this is a data. And I want to split cell with the help of formula. It should be split like this - Please help.?? Here is a attached file..
Thank you for the response sir.
But I want according to screenshot -
Kant Str. (should be in Name column)
46 (should be in Age column)
Berlin (should be in Place column )
Germany(should be in Country column)
Please help...??
But I want according to screenshot -
Kant Str. (should be in Name column)
46 (should be in Age column)
Berlin (should be in Place column )
Germany(should be in Country column)
Please help...??
In english
How To Split Text By Space/Comma/Delimiter In Excel?
If you have a column list of data and you want to split them into several columns by a specific delimiter just like the below screenshots shown, how can you split them in Excel? Maybe some of users think of the Text to Column function only, but now I will introduce not only Text to Columns function, but also a VBA code
Help for self-help.
I am a simple user, who simply offered his knowledge and time voluntarily, with no guarantee.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
