Aad bay ugu badan tahay liisaska si aan kala sooc lahayn loo soo ururiyey ee Excel in xogtu ay ka maqan tahay hakadka kelmadda koowaad ka dib. Tani waa gaar ahaan kiiska marka xogta laga soo min guuriyay tifaftirayaasha erayada. Si aad u heshid sida loo daro koma ka dib kelmadda kowaad ee unug kasta, fadlan akhri maqaalkan.

Waxaad ku dari kartaa comma ka dib kelmadda kowaad unug kasta oo Excel ah laba hab:

1. Isticmaalka shaqada ku celcelinta
2. Isticmaalka shaqada beddelka

Waxaa jira qaacidooyin badan oo lagu daro koma ka dib ereyga ugu horreeya ee unugga. Haddii ay dhacdo in aad haysato liis lagu habeeyey tiirka oo dhan, waxaad ku soo celin kartaa qaacidooyinka liiska adiga oo isticmaalaya ikhtiyaarka Buuxi .^(Fill)

Ku dar comma ka dib ereyga ugu horreeya unug kasta oo ku jira Excel adoo isticmaalaya Ku celcelinta^(Replicate)

Syntax-ka lagu daro comma ka dib kelmad kasta oo ku jirta unug kasta oo ku jira Excel iyadoo la isticmaalayo shaqada Ku- noqoshada^(Replicate) waa sida soo socota:

=REPLACE(<first cell in which you need to add comma>,FIND(" ",<first cell in which you need to add comma>),0,",")

Halkee,

• <unugga koowaad ee aad u baahan tahay inaad ku darto comma> waa unugga ugu horreeya ee liiska ku jira tiirka oo dhan kaas oo aad u baahan tahay inaad ku darto jumlada ka dib ereyga koowaad.

Tusaale ahaan. Aynu ka soo qaadno kiis aan u baahannahay inaan ku darno jumlad ka dib ereyga ugu horreeya ee unug kasta liiska magacyada + ciyaaraha ee qofka ciyaaray. Liisku wuxuu ka bilaabmaa A3 wuxuuna ku dhamaanayaa A7. Waxaan u baahanahay liiska dib loo eegay ee tiirka B.

Habkani waxa uu noqonayaa:

=REPLACE(A3,FIND(" ",A3),0,",")

Geli caanahan unugga B3 oo guji meel kasta oo ka baxsan unugga.

Hadda mar labaad dhagsii unugga B3 si aad u muujiso ikhtiyaarka Buuxi^(Fill) oo hoos ugu soo jiid unugga B8. Waxaad heli lahayd natiijada la rabo.

Ku dar comma ka bacdi erayga kowaad unug kasta oo ku jira Excel addoo isticmaalaya bedelka^(Substitute)

Ereyga ugu horreeya ee unug kasta oo Excel ah oo lagu daro koma ka dib ereyga beddelka^(Substitute) shaqada waa sida soo socota:

=SUBSTITUTE(<first cell in which you need to add comma>," ",", ",1)

Halkee,

• <unugga koowaad ee aad u baahan tahay inaad ku darto comma> waa unugga ugu horreeya ee liiska ku jira tiirka oo dhan kaas oo aad u baahan tahay inaad ku darto jumlada ka dib ereyga koowaad.

Tusaale ahaan. Waxaan isticmaali karnaa isla tusaalihii hore ee liiska gelintadu ka soo bilowdeen unugga A3. Qaabka leh shaqada Beddelku^(Substitute) waxa uu noqonayaa:

=SUBSTITUTE(A3," ",", ",1)

Geli qaaciidadan unugga B3 oo marlabaad isticmaal ikhtiyaarka Buuxi^(Fill) si aad ugu soo koobto qaacidada tiirka oo dhan.

Hoos ugu soo jiid unugga B8 ka dibna ku dhufo meel kasta oo ka baxsan xulashada.

Waxaan rajeyneynaa in xalkani uu ahaa mid waxtar leh!

How to add a Comma after first Word in each Cell in Excel

It is very common in rаndomly compiled lists in Excel that the data is missing commas after the first word. This is especially the case when the data is copied from word editors. To find how to add a comma after the first word in each cell, please read through this article.

You can add a comma after the first word in each cell in Excel by two methods:

1. Using Replicate function
2. Using Substitute function

There are many formulas to add a comma after the first word in a cell. In case you have a list arranged across a column, you can replicate the formula across the list using the Fill option.

Add a comma after the first word in each cell in Excel using Replicate function

The syntax to add a comma after first word in each cell in Excel using the Replicate function is as follows:

=REPLACE(<first cell in which you need to add comma>,FIND(" ",<first cell in which you need to add comma>),0,",")

Where,

• <first cell in which you need to add comma> is the first cell in the list across the column for which you need to add the comma after the first word.

Eg. Let us assume a case where we need to add a comma after the first word in every cell for a list of names + sport played the person. The list starts from A3 and ends at A7. We need the revised list in column B.

The formula would become:

=REPLACE(A3,FIND(" ",A3),0,",")

Enter this formula in cell B3 and click anywhere outside the cell.

Now click on cell B3 again to highlight the Fill option and pull it down to cell B8. You would get the desired result.

Add a comma after the first word in each cell in Excel using Substitute function

The syntax to add a comma after the first word in each cell in Excel using Substitute function is as follows:

=SUBSTITUTE(<first cell in which you need to add comma>," ",", ",1)

Where,

• <first cell in which you need to add comma> is the first cell in the list across the column for which you need to add the comma after the first word.

Eg. We can use the same example as earlier where the list of entries start from cell A3. The formula with the Substitute function would become:

=SUBSTITUTE(A3," ",", ",1)

Enter this formula in cell B3 and again use the Fill option to replicate the formula across the column.

Pull it down to cell B8 and then click anywhere outside the selection.

We hope this solution was helpful!

Related posts

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Kordhi tirada faylalka u dambeeyay ee Word, Excel, PowerPoint

• Sida loogu daro ama looga saaro Xudduudaha Unug ee Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Soo deji Word, Excel, PowerPoint, Access, Visio Templates oo bilaash ah

• Sida loo Furo Word iyo Excel si Badbaado ah

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• 3 Siyood Oo Unugyada Excel Loogu Kala Qaybiyo

• U qaabee qoraalka sidii Superscript ama Subscript ahaan Word, Excel, PowerPoint

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loogu daro Qaamuuska Gaarka ah ee Word, Excel, iyo Outlook

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida loo suurtageliyo Mode-madow ee Word, Excel iyo PowerPoint

• Sida loo nadiifiyo kiliboodhka Excel, Word ama PowerPoint

• Si degdeg ah ugu qor nambarada Word iyo Excel

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel