To split a comma-separated word into separate Excel boxes, such as "New Delhi, Laxmi Nagar, Anand Vihar," you can follow these steps:
1. Copy the cell containing the comma-separated values.
2. Select the cell or cells where you want to split the values.
3. Right-click on the selected cell and choose the "Paste Special" option.
4. In the Paste Special dialog box, select "Values" and then click OK.
5. Now, select the cell with the pasted values.
6. Go to the "Data" tab on the Excel ribbon and click on the "Text to Columns" option.
7. In the Text to Columns Wizard, choose "Delimited" and click Next.
8. Select the delimiter (in this case, comma) and click Next.
9. Choose the format for the split values (general should work in most cases) and click Finish.
By following these steps, you can easily split comma-separated words into separate Excel boxes.