How can I split a text to different columns in Microsoft Excel
My data in col A is as follows:
- 1*15
- 101268*6
- 101352*16
- 101513*11
- 10406*2
- 10406*37
- 10411*13
- 10411*7
I want to add two columns with the data preceding the * going into Col B and the data following the * going into Col C. I can't use RIGHT or LEFT because the data is not the same length. If someone knows a way to do this, I'd certainly appreciate knowing how. Thanks in advance.
Re: How can I split a text to different columns in Microsoft Excel
There is a simple way that you can try out. First have a look at Data, text to columns, post back if you need help with it. You can try searching for more help by pressing F1., There are ample of details provided in the same. Try to search with the exact given keywords.
Re: How can I split a text to different columns in Microsoft Excel
I am not sure that there is any kind of precise schedule or command available that can help you to this. Try this DATA - TEXT COLUMNS. First insert blank columns to the right of where you have data in your case precise 3 empty columns, then select the column that has the data and go to Data - Text to Columns and you follow the wizard asks you which character are separated fields, usually the BLANK, but may be coma, etc.