How to Convert Text to Columns
Feb 3, 2022 03:58:37 AM
BEML layout, 5th Stage, Opp. Rajsri Apartment Rajarajeshwarinagar,
Bangalore, Karnataka,
India 1
08072722287
Follow the steps below to separate your name and state from this.
1. Select the range to be separated. Eg A1:A5.
2. Navigate to the Data Tab and select Text to Columns.
3. You will be presented with the dialogue box shown below; select Delimited and click Next.
4. Uncheck all of the check boxes in Delimiters and check the Space box. because we want to separate names with a space as the delimiter in this example
5. Select Next and then Finish.
https://www.basictutorials.in/how-to-convert-text-to-columns-in-excel.php