There are many functions in Excel which are exceptionally useful and allow us to execute critical tasks in a very straightforward and quick route. Here is one more feature which would enable you to extract the data from one column to multiple. Below are the steps you need to execute to achieve this. 1. Now take the instance of the table in the below screenshot. There are three values presented in this table. 2. Suppose you want to split first text itmacron@profession.com to different cells to itmacron profession.com by removing ' @ ' sign from the middle you need to follow the below steps to do so. 3. Select the entire Column and then Proceed to the ' Menu Bar' and choose ' Data ' and then click on ' Text to Columns' (circled in red in the above screenshot). 4. In this window choose ' Fixed width' with the radio button and click ' Next ' . Further, in the following dialogue box check the ' Other' option and enter ‘@’...
True Solutions