Delete all white space between the words in one cell

elisa

New Member
Joined
Apr 24, 2002
Messages
7
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.
 
I have this cell with this text:

"

Produs in Romania!



Mod de preparare:

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?
 
Upvote 0

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
How can I remove all the extra spaces but keep the spaces between each word?


trim.JPG
 
Upvote 0

Forum statistics

Threads
1,214,854
Messages
6,121,941
Members
449,056
Latest member
denissimo

We've detected that you are using an adblocker.

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.
Go back
Back
Top