Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How To Split The Contents In Cells Of Excel Worksheets

No comments
I have several rows of data this morning that I like to divide into columns. Each cell contains data that looks like this "ABCD - EFG - 1000". The common delimiter is hyphen ("-"). To split the contents into three columns, I used the following steps:

1. Select all the cells you want to split.

How To Split The Contents In Cells Of Excel Worksheets

2. Go to Data menu and hit the "Text to Columns" menu item.
3. From the Wizard, select the delimited option and click next.

Convert Text To Columns Wizard In Excel

4. On the delimiters, check the "other" box and put hyphen "-" on the textbox beside it. Click Next to proceed.



5. Click Finish.

No comments :

Post a Comment