I know that there is a TRIM function that delete extra space between words in a cell. How do you delete all space in a cell.
ex. "White Space" == "WhiteSpace" Is there a function for it, that is similiar to TRIM function?
Thank you.
Se poate consuma simplu, ca adaos in macaruri, supe, salate, ciorbe, proportia minima fiind de o lingura/persoana, zilnic.
Desert din Complex Forte:
Se amesteca produsul pana devine o pasta alba omogena. Se adauga nuci maruntite, stafide, fructe de sezon bine coapte, suc de lamaie sau portocala. Aceasta compozitie poate fi folosita ca blat pentru tort, turnandu-se peste ea o crema de fructe si Digesta.
Salata cu fructe si smantana:
Ingrediente (pt. o persoana):2 linguri "Complex Forte", 4-5 linguri apa, 1 mar ras, 2 linguri zeama de lamaie, 2 linguri smantana, 1-2 lingurite miere, fructe uscate sau proaspete.
Se amesteca produsul cu apa si se lasa 5 minute. Apoi se adauga marul ras, zeama de lamaie, smantana, fructele si mierea. Se serveste imediat.
<colgroup><col></colgroup><tbody>
</tbody>
"
How can I remove all the extra spaces but keep the spaces between each word?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.