Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Bain spásanna i gcealla Excel - spásanna tosaigh, spásanna ráille, spásanna breise nó gach spás

Uaireanta, nuair a dhéantar sonraí a chóipeáil agus a ghreamú ó fheidhmchláir eile i mbileog oibre, d’fhéadfadh go rachadh rud éigin mícheart má thagann spásanna breise go neamhfhiosach in éineacht leis na sonraí. Mar shampla, nuair a chuirfear dhá chillchealla leis lena n-áirítear spásanna tosaigh, fillfidh sé an toradh mar 0 in ionad an toraidh cheart; Nó faigh an toradh mícheart agus tú ag comparáid idir dhá chealla leis an ábhar céanna ach ceann acu ina bhfuil spásanna ceannródaíocha nó rianaithe. Conas na spásanna seo a bhaint? Tabharfaidh an rang teagaisc seo roinnt modhanna duit.


Bain spásanna breise lena n-áirítear spásanna tosaigh, rianaithe agus barraíocht spásanna eatarthu ó chealla

Má cheaptar go bhfuil liosta colún agat de chealla ina bhfuil spásanna tosaigh, rianaithe agus barraíocht spásanna eatarthu. Chun na spásanna breise seo go léir a bhaint de chealla, is féidir le feidhm TRIM cabhrú.

=TRIM(TEXT)

Roghnaigh cill bhán, iontráil =TRIM(B3) isteach ann agus brúigh an Iontráil eochair. Agus ansin tarraing a Líon Láimhseáil síos chun an fhoirmle a chur i bhfeidhm ar chealla eile. Féach an pictiúr:
nótaí: Is é B3 an chill ina bhfuil an téacs as a dteastaíonn uait spásanna a bhaint.

Anois baintear na spásanna breise go léir lena n-áirítear spásanna tosaigh, rianaithe agus barraíocht spásanna eatarthu ó na cealla sonraithe.

nótaí: Is gá an oibríocht seo a dhéanamh i gcolún nua. Tar éis duit na spásanna breise go léir a bhaint, ní mór duit na sonraí bearrtha a chur in ionad na sonraí bunaidh trí bhrú ar an Ctrl + C, roghnaigh an raon sonraí bunaidh agus cliceáil ar dheis chun roghnú luachanna faoi ​​na Greamaigh Roghanna alt seo.

Roinnt Cliceáil chun Spásanna Neamhbhealaithe a Bhaint as Cealla

Leis an Bain Spásanna fóntais, ní fhéadfaidh ach cúpla cad a tharlaíonn cabhrú leat fáil réidh ní amháin spásanna tosaigh, spásanna traenála, spásanna breise ach freisin gach spás ó raon, raonta iolracha nó fiú an bhileog oibre iomlán, rud a shábhálfaidh go leor de do chuid ama oibre.
Kutools le haghaidh Excel - Bailíonn sé níos mó ná 300 gné chumhachtach chun cinn, atá deartha le haghaidh 1500+ cás oibre, fadhbanna 80% Excel a réiteach.

Íoslódáil agus bain triail as an triail iomlán saor in aisce 30 lá

 

Bain ach spásanna tosaigh ó chealla

I roinnt cásanna, b’fhéidir go mbeidh ort na spásanna tosaigh a bhaint agus na spásanna go léir idir cealla a choinneáil mar a thaispeántar an pictiúr thíos. Tugann an chuid seo foirmle eile agus cód VBA isteach chun an fhadhb seo a réiteach.

Úsáid feidhm MID chun spásanna tosaigh amháin a bhaint

Roghnaigh cill bhán (roghnaigh mé cill D3 anseo), cóipeáil an fhoirmle thíos isteach agus brúigh an Iontráil eochair. Agus ansin tarraing an Líon Láimhseáil síos chun an fhoirmle a chur i bhfeidhm ar chealla eile.

=MID(B3,FIND(MID(TRIM(B3),1,1),B3),LEN(B3))

San fhoirmle seo, B3 an cill ina bhfuil an téacs as a dteastaíonn uait spásanna tosaigh a bhaint.

nótaí: Is gá an oibríocht seo a dhéanamh i gcolún nua. Tar éis duit na spásanna tosaigh go léir a bhaint, ní mór duit na sonraí bearrtha a chur in ionad na sonraí bunaidh gan foirmlí.

Úsáid cód VBA chun spásanna tosaigh amháin a bhaint

1. Oscail an bhileog oibre tá na cealla a mbainfidh tú spásanna tosaigh astu, agus ansin brúigh an Eile + F11 eochracha a oscailt Microsoft Visual Basic d’Fheidhmchláir fhuinneog.

2. cliceáil Ionsáigh > Modúil, ansin cóipeáil thíos cód VBA isteach i bhfuinneog an Mhodúil.

Sub RemoveLeadingSpaces()
'Updateby20190612
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = VBA.LTrim(Rng.Value)
Next
End Sub

3. Brúigh an F5 eochair chun an cód a rith. A. Kutools le haghaidh Excel tagann dialóg suas, roghnaigh na cealla leanúnacha a mbainfidh tú spásanna tosaigh astu, agus ansin cliceáil ar an OK cnaipe.

Anois ní fheiceann tú ach na spásanna tosaigh a bhaintear as na cealla roghnaithe.


Bain ach spásanna ráille as cealla

1. Oscail an bhileog oibre tá na cealla a mbainfidh tú spásanna tosaigh astu, agus ansin brúigh an Eile + F11 eochracha a oscailt Microsoft Visual Basic d’Fheidhmchláir fhuinneog.

2. cliceáil Ionsáigh > Modúil, ansin cóipeáil thíos cód VBA isteach i bhfuinneog an Mhodúil.

Sub RemoveTrailingSpaces()
'Updateby20190612
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = VBA.RTrim(Rng.Value)
Next
End Sub

3. Brúigh an F5 eochair chun an cód a rith. A. Kutools le haghaidh Excel tagann dialóg suas, roghnaigh na cealla leanúnacha a mbainfidh tú spásanna ráille astu, agus ansin cliceáil ar an OK cnaipe. Anois ní fheiceann tú ach na spásanna ráille a bhaint de na cealla roghnaithe.


Bain na spásanna go léir ó chealla

Más mian leat fáil réidh leis na spásanna go léir i gcealla ar leith, is féidir le modhanna sa chuid seo fabhar a thabhairt duit.

Úsáid feidhm SUBSTITUTE chun na spásanna go léir a bhaint de chealla

=SUBSTITUTE(text, old_text, new_text, [instance_num])

Roghnaigh cill bhán, cóipeáil an fhoirmle thíos isteach agus brúigh an Iontráil eochair. Ansin tarraing an Líon Láimhseáil síos chun an fhoirmle a chur i bhfeidhm ar chealla eile.

=SUBSTITUTE(B3," ","")

Leideanna: San fhoirmle seo, B3 an bhfuil an chill ina bhfuil téacs ar mhaith leat na spásanna go léir a bhaint dó;
         "" (spás atá iata le comharthaí athfhriotail dúbailte) anseo na spásanna a theastaíonn uait a bhaint;
         "" ciallaíonn anseo go gcuirfidh tú aon spás in ionad na spásanna go léir.

Ansin feiceann tú go mbaintear gach spás i gcealla ar leith láithreach.

nótaí: Is gá an oibríocht seo a dhéanamh i gcolún nua. Tar éis duit na spásanna go léir a bhaint, ní mór duit na sonraí bearrtha a chur in ionad na sonraí bunaidh gan foirmlí.

Úsáid feidhm Aimsigh & Ionadaigh chun na spásanna go léir a bhaint de chealla

Seachas an méid thuas SUBSTITUTE feidhm, is féidir leis an ngné Aimsigh & Ionadaigh cuidiú leis na spásanna go léir a bhaint de chealla.

1. Roghnaigh na cealla ina bhfuil spásanna a bhainfidh tú, brúigh an Ctrl + H eochracha a oscailt Aimsigh agus Ionadaigh dialóg.

2. Sa Aimsigh agus Ionadaigh dialóg agus faoin Ionadaigh cluaisín, clóscríobh spás amháin isteach sa Aimsigh cad bosca téacs, coinnigh an Ionadaigh le bosca téacs folamh, agus ansin cliceáil ar an Ionadaigh uile cnaipe.


Bain spásanna tosaigh, ráille, breise agus gach spás go héasca ó chealla leis na Kutools

Leid: Má tá tú bréan de úsáid a bhaint as foirmlí agus cóid VBA chun spásanna a bhaint, beidh an Bain Spásanna fóntais de Kutools le haghaidh Excel Is é do rogha is fearr. Gan ach cúpla cad a tharlaíonn, is féidir leat ní amháin spásanna tosaigh, spásanna traenála, spásanna iomarcacha ach gach spás a bhaint ó raon, ilréimsí nó fiú an bhileog oibre iomlán, rud a shábhálfaidh go leor de do chuid ama oibre.

Sula n-úsáideann tú na Kutools le haghaidh Excel, ní mór duit nóiméad a thógáil chuig íoslódáil saor in aisce agus é a shuiteáil ar dtús.

1. Roghnaigh raon nó iliomad raonta leis na cealla a mbainfidh tú spásanna astu, cliceáil Kutools > Téacs > Bain Spásanna. Féach an pictiúr:

2. Feiceann tú go bhfuil 5 rogha sa Bain Spásanna bosca dialóige:

  • Chun na spásanna tosaigh amháin a bhaint, roghnaigh an Spásanna ceannais rogha;
  • Chun na spásanna ráille a bhaint, roghnaigh an Spásanna ráille rogha;
  • Chun na spásanna tosaigh agus na spásanna ráille a bhaint ag an am céanna, roghnaigh an Spásanna Ceannaireachta & Rianaithe rogha;
  • Chun na spásanna breise go léir a bhaint (lena n-áirítear spásanna tosaigh, rianaithe, barraíocht spásanna eatarthu), roghnaigh an Gach spás breise rogha;
  • Chun na spásanna go léir a bhaint, roghnaigh an Gach spás rogha.

Ansin cliceáil ar an OK cnaipe chun an oibríocht a thosú.

  Más mian leat triail saor in aisce (30 lá) a bheith agat ar an bhfóntas seo, cliceáil le do thoil chun é a íoslódáil, agus ansin téigh chun an oibríocht a chur i bhfeidhm de réir na gcéimeanna thuas.


Bhain cásanna praiticiúla eile le spásanna Excel

Seachas spásanna a bhaint de chealla, an raibh tú riamh ag tabhairt aghaidhe ar chúinsí comhaireamh, spásanna a chur leis, nó carachtair eile i gcealla a chur in áit na spásanna? D’fhéadfadh go gcuirfeadh an moladh thíos dlús le d’obair Excel.

Líon na spásanna iomlána i gcill
Sula mbainfidh tú na spásanna go léir ó chill, b’fhéidir go mbeidh tú fiosrach faoi cé mhéad spás atá ann. Soláthraíonn an teagaisc seo modhanna i gcéimeanna mionsonraithe chun cabhrú leat líon iomlán na spásanna i gcill a fháil go tapa.
Cliceáil chun níos mó eolais a fháil ...

Cuir spás i ndiaidh gach camóg i gcealla Excel ar leith
Uaireanta, d’fhéadfaí spásanna a bhaint de thaisme ó chealla ar leith. Tá an rang teagaisc seo ag caint ar spás a chur leis tar éis gach camóg chun an sreangán téacs a dhéanamh níos soiléire agus níos caighdeánaí le céimeanna mionsonraithe.
Cliceáil chun níos mó eolais a fháil ...

Cuir spásanna idir uimhreacha i gcealla Excel
Tá an rang teagaisc seo ag caint ar spás a chur idir gach uimhir nó gach naoú uimhir i gcealla Excel. Má cheaptar go bhfuil colún d’uimhreacha gutháin agat, agus gur mhaith leat spásanna a chur eatarthu le go mbeidh cuma níos iomasach agus níos éasca ar an uimhir a léamh. Cabhróidh modhanna sa rang teagaisc seo.
Cliceáil chun níos mó eolais a fháil ...

Cuir spásanna os comhair ceannlitreacha i gcealla Excel
Tá an rang teagaisc seo ag caint ar spás a chur roimh gach ceannlitir i gcealla Excel. Má cheaptar go bhfuil liosta de shreangáin téacs agat agus na spásanna go léir bainte trí thimpiste, mar seo: InsertBlankRowsBetweenData, chun na spásanna a chur roimh gach ceannlitir chun na focail a scaradh mar Ionsáigh Blank Rows Between Data, bain triail as na modhanna sa rang teagaisc seo.
Cliceáil chun níos mó eolais a fháil ...

Cuir carachtar faoi leith i gcealla Excel
In a lán cásanna, b’fhearr leat spásanna a chur in ionad carachtair ar leith seachas iad a bhaint ó chealla go díreach. Soláthraíonn sé seo modhanna duit chun béim a chur ar spás go héasca le béim, Fleasc nó camóg i gcealla.
Cliceáil chun níos mó eolais a fháil ...



  • Barra Foirmle Super (cuir línte iolracha téacs agus foirmle in eagar go héasca); Leagan Amach Léitheoireachta (líon mór cealla a léamh agus a chur in eagar go héasca); Greamaigh go dtí an Raon Scagtha...
  • Cumaisc Cealla / Sraitheanna / Colúin agus Sonraí a Choinneáil; Ábhar Cealla Scoilt; Comhcheangail Sraitheanna Dúblacha agus Suim / Meán... Cill Dúblach a Chosc; Déan comparáid idir Ranganna...
  • Roghnaigh Dúblach nó Uathúil Sraitheanna; Roghnaigh Blank Rows (tá na cealla uile folamh); Aimsigh Super agus Fuzzy Aimsigh i go leor Leabhar Oibre; Roghnaigh go randamach ...
  • Cóip Díreach Cealla Il gan tagairt fhoirmle a athrú; Tagairtí Cruthaigh Auto chuig Bileoga Il; Cuir Urchair isteach, Boscaí Seiceála agus go leor eile ...
  • Foirmlí is Fearr agus Cuir isteach go tapa, Ranganna, Cairteacha agus Pictiúir; Cealla a Chriptiú le pasfhocal; Cruthaigh Liosta Ríomhphoist agus seol ríomhphoist ...
  • Sliocht Téacs, Cuir Téacs leis, Bain de réir Poist, Bain Spás; Subtotals Paging a chruthú agus a phriontáil; Tiontaigh Idir Ábhar Cealla agus Tráchtanna...
  • Scagaire Super (scéimeanna scagaire a shábháil agus a chur i bhfeidhm ar bhileoga eile); Ard-Sórtáil de réir míosa / seachtaine / lae, minicíocht agus níos mó; Scagaire Speisialta le cló trom, iodálach ...
  • Comhcheangail Leabhair Oibre agus Bileoga Oibre; Cumaisc Táblaí bunaithe ar eochaircholúin; Roinn Sonraí i Ilbhileoga; Baisc Tiontaigh xls, xlsx agus PDF...
  • Grúpáil Tábla Pivot de réir uimhir na seachtaine, lá na seachtaine agus níos mó ... Taispeáin Cealla Díghlasáilte, Faoi Ghlas de réir dathanna éagsúla; Aibhsigh Cealla a bhfuil Foirmle / Ainm orthu...
cluaisín kte 201905
  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
bun officetab
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Da345 · 2 years ago
    I removed all spaces with the Replace function, very easy, thank you
  • To post as a guest, your comment is unpublished.
    javad · 2 years ago
    thank you a lot

    it was very god
  • To post as a guest, your comment is unpublished.
    Rafik · 3 years ago
    Thank you a lot.
  • To post as a guest, your comment is unpublished.
    Ocaya · 4 years ago
    Excellent, Very helpful
  • To post as a guest, your comment is unpublished.
    alefpe · 4 years ago
    Thank you very much.
    It was so helpful.
  • To post as a guest, your comment is unpublished.
    alfonso · 4 years ago
    if it doesnt work for you. First you remove the spaces, then you remove the letters, for example: i have USD 1234.00 , first i do the find & replace just the space between USD and 1234.00, now i have USD1234.00, now i go back to find & replace and on find what: i put USD ( no spaces ), and nothing on REPLACE WITH: then i click on Replace all , and i have now 1234.00 if you do it the other way it doesnt work i dont know why.
  • To post as a guest, your comment is unpublished.
    ArvRajB · 4 years ago
    Thank you very much!!
  • To post as a guest, your comment is unpublished.
    Cecep Saefulloh · 4 years ago
    Great Tips especially for research keywords and to make a lot of hashtags on facebook, and You have great tools to make it simple

    It is appropriate that we visit each other and communicate
    Web Development Agency Konsultan Blog Teknologi
  • To post as a guest, your comment is unpublished.
    Joseph Wokwera · 4 years ago
    Thanks so much helpful. i ve been trying this for 2 days. it worked
  • To post as a guest, your comment is unpublished.
    PRAMOD · 4 years ago
    Excellent.Very helpful to remove space in a cell
  • To post as a guest, your comment is unpublished.
    PRAMOD · 4 years ago
    Excellent, nice formula to substitute or remove the spaces in a cell.
  • To post as a guest, your comment is unpublished.
    sachin · 4 years ago
    Thank You Very Much. help me a lot..
  • To post as a guest, your comment is unpublished.
    SUDHIR MISHRA · 5 years ago
    EXCELLENT :) THANK FOR HELP
  • To post as a guest, your comment is unpublished.
    Kosova · 5 years ago
    Thanks a lot, now its so easy.
  • To post as a guest, your comment is unpublished.
    RDM · 5 years ago
    THANK YOU! Really helped me and my bandwidth
  • To post as a guest, your comment is unpublished.
    Sharil · 5 years ago
    Oh its amazing, i didn't knew about to remove the space between words in a cell....its so easy...thanku so much.
  • To post as a guest, your comment is unpublished.
    Ashok Kumar R · 5 years ago
    :-) good.. any move issue please mail me
  • To post as a guest, your comment is unpublished.
    Dinesh · 5 years ago
    i am using MS 2010 ,how to remove all space in excel. exmple also give
  • To post as a guest, your comment is unpublished.
    JUNAID · 5 years ago
    Thanks a lot for helping us!!!!!!!!! :-)
  • To post as a guest, your comment is unpublished.
    JUNAID · 5 years ago
    THANKS A LOT FOR HELPING US!!!!!!!!!!!!!!
  • To post as a guest, your comment is unpublished.
    Suresh · 6 years ago
    Thanks a lot for sharing this Tool :-)
  • To post as a guest, your comment is unpublished.
    KD · 6 years ago
    Thank You. Your help has reduced my effort a lot.
  • To post as a guest, your comment is unpublished.
    Henman · 6 years ago
    Neither of these suggestions work... except, I'm sure, the Kutools solution so conveniently suggested. What an awesome blog. Thanks.
  • To post as a guest, your comment is unpublished.
    Mr.Niekoo · 6 years ago
    How i can remove dots from my columns of excel.I want to remove all dots from full list of columns.The data consist on Phone no's list

    email me
    mr.niekoo@hotmail.com
  • To post as a guest, your comment is unpublished.
    rajesh · 6 years ago
    Great command, It is very usefull.
  • To post as a guest, your comment is unpublished.
    Maria · 6 years ago
    I don't have kutools and I tired all formulas, eventually I had the trailing spaces removed from behind a date. However, excel still does not recognize the entry as a "date" and cannot sort by date, even though the format is date. So I have to enter each cell and F2. We are talking thousands of cells in a column... Can anyone give suggestions?
    • To post as a guest, your comment is unpublished.
      Imran · 4 years ago
      [quote name="Maria"]I don't have kutools and I tired all formulas, eventually I had the trailing spaces removed from behind a date. However, excel still does not recognize the entry as a "date" and cannot sort by date, even though the format is date. So I have to enter each cell and F2. We are talking thousands of cells in a column... Can anyone give suggestions?[/quote]
      Select the column--> go to Data> Text to column> select delimited> next> next> change the date format as MDY or DMY as the case in your sheet> press fininsh.
  • To post as a guest, your comment is unpublished.
    M&M · 6 years ago
    Replace option is the best and easiest! Thanks for sharing the tips!
  • To post as a guest, your comment is unpublished.
    Yasar Arafath · 6 years ago
    Remove space before and after the cell content (Eg:___26350__)
    We can use this formula =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))
    • To post as a guest, your comment is unpublished.
      Manish · 5 years ago
      Thanks a lot:):):).... It saved a lot of time....keep on updating such useful and very rate instances!!!!!!
  • To post as a guest, your comment is unpublished.
    Sushen · 6 years ago
    Very use full command
  • To post as a guest, your comment is unpublished.
    carla · 6 years ago
    Thank you! very helpful. saved the day.
  • To post as a guest, your comment is unpublished.
    kirtan · 6 years ago
    tried all the options above. not working as there are spaces before and after number. Any other alternative?
    • To post as a guest, your comment is unpublished.
      Yasar Arafath · 6 years ago
      Try this one

      =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))
  • To post as a guest, your comment is unpublished.
    karan · 6 years ago
    very helpful :) and easy to understand

    ;-)
  • To post as a guest, your comment is unpublished.
    Anna · 6 years ago
    Very helpful!
    Thank you
  • To post as a guest, your comment is unpublished.
    GaryMonday · 6 years ago
    Thank you very much for the trick, very very useful, it makes my spreadsheet a lot neater.

    Thanks again.

    Gary
  • To post as a guest, your comment is unpublished.
    Prabhakar · 6 years ago
    Wow its fantastic small commands work very well
  • To post as a guest, your comment is unpublished.
    ilham · 6 years ago
    wow thanks ..useful :-) :):):):):):)
  • To post as a guest, your comment is unpublished.
    BISHNU · 6 years ago
    I like this tools very much
  • To post as a guest, your comment is unpublished.
    KALPESH SUTHAR · 7 years ago
    Thanks a lot....its really helpful..save lot of time... :-)
  • To post as a guest, your comment is unpublished.
    corpsman0000 · 7 years ago
    how do you remove spaces without removing the zeros that in the begining of values middle and end? i just want to remove the spaces in between the values only. i tried the above and the zeros disappeared.
    • To post as a guest, your comment is unpublished.
      Avi · 6 years ago
      Convert the cell into text format then use replace function
  • To post as a guest, your comment is unpublished.
    Ranjith Kumar · 7 years ago
    Thanks Very very use full
  • To post as a guest, your comment is unpublished.
    Eva · 7 years ago
    Thanks for finally talking about >How to remove spaces between character and numbers within cells in Excel?
  • To post as a guest, your comment is unpublished.
    Rebeccah · 7 years ago
    Find/replace doesn't work for me, which is why I'm googling this topic in the first place. Is there a setting somewhere that disables this?

    I want to delete ":" form the cells in a column (and "/" from the cells in another column). I ought to be able to highlight the column, ^H, type ":" (or "/") in the find field, leave the replace field blank, and click Replace All, and it should do it. Or Find Next/Replace/Replace/Replace through the cells one at a time. But it advances therough the cells but doesn't do anything. If I put something in the replace field, it will do the replace, but it won't replace with an empty string.
  • To post as a guest, your comment is unpublished.
    Stefan · 7 years ago
    Thank you, easy to understand. best on the web
  • To post as a guest, your comment is unpublished.
    Janardhan · 7 years ago
    Very easy to understand. Good to follow.
    • To post as a guest, your comment is unpublished.
      ashutosh · 6 years ago
      bullshit....doesn't work
      • To post as a guest, your comment is unpublished.
        Joel · 5 years ago
        Didnt work for me too, however found the right way. Select and highlight the space you want to get rid of. Copy this space and select the find and replace. Paste this space in find and replace with nothing. I guess it wasnt a space in the first place. Whatever it was you now find it by copying whatever it was. Hope it works for you.
        • To post as a guest, your comment is unpublished.
          Ramesh Kumar P · 4 years ago
          It really worked....I tried may function like Clean, Trim, Substitute, etc
        • To post as a guest, your comment is unpublished.
          Jay · 4 years ago
          THAT WORKED! Thanks man
        • To post as a guest, your comment is unpublished.
          kati · 4 years ago
          thanks soo much. you are a genius!!!!
        • To post as a guest, your comment is unpublished.
          Imran · 4 years ago
          [quote name="Erika"]It worked for me! Thank you![/quote]
          Thank you so much for that. This saved a lot of time
        • To post as a guest, your comment is unpublished.
          Erika · 5 years ago
          It worked for me! Thank you!
  • To post as a guest, your comment is unpublished.
    Muhibullah Afzalzada · 7 years ago
    Thanks a lot, the Replace option worked as a charm... you really saved loads of my time.
  • To post as a guest, your comment is unpublished.
    Muhibullah Afzalzada · 7 years ago
    Thanks a lot, I really needed and the Replace option was a charm.
    • To post as a guest, your comment is unpublished.
      Stephen · 4 years ago
      Thanks a lot for the explanation - saved our dept a lot of work.