Excel How to Apply Text to Columns (Fixed Width)
Автор: Romeo Costillas
Загружено: 2017-10-04
Просмотров: 1307
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: