Haddii unuggu ka kooban yahay xoogaa qoraal ah oo ay kala soocaan joodar ama calaamad kale, oo aad rabto inaad u kala qaybiso tiirar badan, waa inaad raacdaa hagahan. Maqaalkani waxa uu kaa caawin doonaa in aad kala qaybiso qoraalka kala qaybsan^{(split comma-separated text)} ee Excel iyo Google Sheets adoon isticmaalin software dhinac saddexaad ah.

Aynu ka soo qaadno inaad haysatid xaashi ka kooban magaca dadka qaarkii oo buuxa, oo aad doonayso inaad magaca hore iyo magaca dambe u kala qaybiso laba tiir. Halkii magacyada, waxa ku jiri kara wax kasta sida liiska alaabta, adeegyadaada, iyo qiimaha, ama wax kale. Haddii tirada safku yar tahay, waxaad ku samayn kartaa gacanta. Dhibaatadu waxay dhacdaa marka aad u baahan tahay inaad sidaas oo kale ku sameyso boqolaal tiir oo ku jira Microsoft Excel ama Google Sheets . Si aad uga takhalusto shaqadaas waqti-qaadka ah, waxaad ku eegi kartaa tillaabadan hage-tallaabo.

Sida qoraalka^{(Split Text)} loogu kala qaybiyo tiirarka^(Columns) gudaha Excel

Si aad u kala qaybiso qoraalka kala soocan ee Excel , raac talaabooyinkan-

1. Fur xaashida oo door dhammaan unugyada.
2. Tag tab xogta
3. Guji^(Click) ikhtiyaarka Text to Columns .
4. Isticmaal ikhtiyaarka xaddidan oo dooro xad- dhaafiye^(Delimited) .
5. Dooro unug meesha aad rabto inaad ku muujiso natiijada.
6. Kaydi faylkaaga

Si aad u bilowdo, waxaad u baahan tahay inaad furto xaashida xisaabaadka ee Microsoft Excel oo aad doorato dhammaan unugyada ay ku jiraan qoraallada kala soocan. Taas ka dib, u tag xogta^{(Data )} tab oo guji Text to Columns option.

Waxaad heli doontaa laba ikhtiyaar - Balac^(Delimited) xaddidan iyo go'an^{(Fixed Width)} . Waxaad u baahan tahay inaad doorato ikhtiyaarka xaddidan^(Delimited) oo guji badhanka Xiga^{(Next )} .

Intaa ka dib, dooro xad- dhaafiye^(Delimiter) . Maadaama xaashida xaashidaadu leedahay comma, waxaad u baahan tahay inaad ka doorato liiska. Si kastaba ha ahaatee, waa suurtogal in la doorto shay kale sida Tab , Semicolon , Space , ama wax kasta oo caado ah. Ugu dambeyntii, dhagsii badhanka Xiga^{(Next )} .

Hadda waxaad u baahan tahay inaad doorato unug si aad u noqoto tiirka koowaad.

Ku soo noqoshada hagaha, waxaad u baahan tahay inaad meesha ka saarto qiimaha Meesha^{(Destination )} , oo dooro unug meesha aad rabto inaad ku muujiso wax soo saarka. Ugu dambeyntii, dhagsii badhanka dhame^{(Finish )} .

Unug kasta ama tiir kasta oo aad doorato, kan ku xiga ayaa yeelan doona qaybta ugu dambeysa ee qoraalka kala-saaran.

Tusaale ahaan, haddii-

• Waxaad haysaa qoraal kan oo kale ah - AA, BB
• U dooro B1 ee AA

Qaybta BB waxa lagu kaydin doonaa unugga C1. Haddii qoraalka ishaadu ka kooban yahay laba hakad, qaybta ugu dambeysa ayaa lagu soo bandhigi doonaa unugga D1.

Hadda, waxaad isla markiiba heli kartaa natiijada.

Sida loo qaybiyo qoraalka kala soocan ee Google Sheets

Xaaladdan oo kale, Google Sheets maaha mid caqli badan sida Microsoft Excel . Inkasta oo aad kala qaybin karto dhammaan qoraallada kala-saaran, ma sii haysan kartid tiirka isha. Haddii aad taas ku fiican tahay, waa inaad soo martaa tillaabooyinkan.

1. Dooro^(Select) dhammaan unugyada xaashidaada.
2. Tag Data > Split qoraallada tiirarka.
3. Beddel kala soocida haddii aad rabto.

Marka hore, waxaad u baahan tahay inaad doorato dhammaan unugyada ay ku jiraan qiimayaasha kala-saaran Intaa ka dib, balaadhi liiska xogta^{(Data )} oo dooro U kala qaybi qoraalka xulashada tiirarka^{(Split text to columns)} .

Sida caadiga ah, waxay si toos ah u ogaanaysaa kala-soocida ama xadeeyaha. Haddii aad isticmaaleyso shay gaar ah ama uusan u qaban shaqada si cillad la'aan ah, waxaad ballaarin kartaa liiska hoos-u-dhaca kala soocida, oo dooro wax kale iyadoo loo eegayo shuruudahaaga .^(Separator)

Waa kaas!

How to split Text to Columns in Excel and Google Sheets

If a cell contains some text separated by comma or any other mark, and yоu want to sрlit them into multiple columns, you should follow this guide. This article will help you split comma-separated text in Excel and Google Sheets without using any third-party software.

Let’s assume that you have a spreadsheet containing the full name of some people, and you want to split the first name and last name into two columns. Instead of names, it can include anything like product list, your services, and price, or anything else. If the number of rows is small, you can do it manually. The problem occurs when you need to do the same with hundreds of columns in either Microsoft Excel or Google Sheets. To get rid of that time-consuming work, you can check out this step by step guide.

How to Split Text to Columns in Excel

To split comma-separated text in Excel, follow these steps-

1. Open the spreadsheet and select all cells.
2. Go to the Data tab.
3. Click on the Text to Columns option.
4. Use the Delimited option and select a delimiter.
5. Select a cell where you want to display the result.
6. Save your file.

To get started, you need to open the spreadsheet in Microsoft Excel and select all the cells that contain command separated texts. After that, go to the Data tab and click on Text to Columns option.

You will get two options – Delimited and Fixed Width. You need to choose the Delimited option and click the Next button.

After that, select a Delimiter. As your spreadsheet has a comma, you need to select it from the list. However, it is possible to choose something else like Tab, Semicolon, Space, or anything custom. At last, click on the Next button.

Now you need to choose a cell to be the first column.

Coming back to the guide, you need to remove default Destination value, and select a cell where you want to display the output. At last, click the Finish button.

Whatever cell or column you choose, the very next one will have the last part of the comma-separated text.

For instance, if-

• You have a text like this – AA, BB
• Select B1 for AA

The BB part will be saved in the C1 cell. If your source text contains two commas, the very last part will be displayed in the D1 cell.

Now, you can find the result immediately.

How to split comma separated text in Google Sheets

In this case, Google Sheets is not as smart as Microsoft Excel. Although you can split all comma-separated texts, you cannot retain the source column. If you are okay with that, you should walk through these steps.

1. Select all cells in your spreadsheet.
2. Go to Data > Split texts to columns.
3. Change separator if you want.

At first, you need to select all the cells that contain comma-separated values. After that, expand the Data menu and select Split text to columns option.

By default, it detects the separator or delimiter automatically. If you are using something unique or it doesn’t do the job flawlessly, you can expand the Separator drop-down list, and choose something else according to your requirement.

That’s it!

Related posts

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo sameeyo liiska hoos u dhaca ee Excel iyo Google Sheets

• Sida loogu xidho Google Sheets iyo Excel

• Sida loo sameeyo garaaf xariiq qaloocan gudaha Excel iyo Google Sheets

• Xaashiyaha Google ee ugu Fiican iyo Hababka Jadwalka Kalandarka ee Excel Online

• U samee xiriir toos ah Google Sheets PDF isku xirka Google Drive

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Sida loo qaboojiyo safafka iyo tiirarka gudaha Excel

• Sida otomaatig loogu sameeyo hawlaha xaashida Google ee Macros

• U kala qaybso dukumeenti ku jira Google Docs

• U beddelo Word, PowerPoint, Excel Documents PDF adoo isticmaalaya Google Docs

• Sida loo beddelo Kiiska qoraalka ee Word iyo Google Sheets

• Sida loo dejiyo xadka Character ee Excel iyo Google Sheets

• Sida faylka Excel loogu beddelo PDF onlayn addoo isticmaalaya Google Drive

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo geliyo WordArt xaashida Google-ka iyadoo la isticmaalayo Google Drawings

• Sidee si degdeg ah loogu duubaa qoraalka xaashida Google?

• Sida loo codsado Midabka safafka ama Saafka kale ee Excel

• Sida loogu daro Multiple Formating qoraalkaaga hal unug oo Excel ah

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel