Excel How to Apply Text to Columns (Fixed Width)

Описание: Excel Text to Columns (Fixed Width)

1. Copy and paste the following data to cells A2:A10
PH19811225
AU20100819
CA20141110
UK20170214
IT20130524
SG20140915
MY19991021
QA19870315
NZ20010415

2. Highlight range A2:A10
3. Go to Data Ribbon tab and click “Text to Columns”
4. Select “Fixed Width” then click “Next”
5. Create break line/s by clicking at the desired position in the image
6. After creating break line/s, click “Next”
7. Select cell B2 as your destination cell
8.Then hit “Finish” button

Have fun learning Excel!

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
   / @romeocostillas  

YouTube Playlist:
   • Excel Keyboard Shortcut Control Combinatio...  

Or visit me on Facebook at   / excelbyromeocostillas  

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert



"To excel in the workplace, one must know how to use EXCEL"
Romeo

#excel #microsoftexcel #excelbyromeocostillas #excelmasterclass #excelexpert #excelfreetraining #excel