remove space

  1. N

    How to delete one space in the end of cell?

    I have multiple tabs witd data. On some cells there seems to be one space in the end of cell. How can I remove it? Best option would be to remove that last space on all tabs at once, but also help how to remove them on single tab would help. I have already tried simple TRIM, but it leaves the...
  2. Z

    Remove Asterisk and extra space from cell

    Hi, I need to remove Asterisk and extra space from cell check this. <tbody> <tbody> Original Description After Clean Asterisk and Space Get a sparkly look with Our Signature Swarovski Crystal Teardrop Stud Earrings, faceted for extra shine in a delicious variety of colors finishes...
  3. D

    Trim / Substitute Question - Removing CERTAIN Spaces from names in a column

    First post, hope I'm doing everything correctly...I tried searching this and couldn't find what I needed and I'm in a bit of a hurry, so I hope I explain myself well enough that someone can help quickly. Ok, so here goes: I copied and pasted a table of data from a website - columns have a...
  4. L

    Remove Spaces Before a Comma Only

    Hello all, I'm looking for a formula to remove a space, if it exists, before a comma. For instance, I need "Golden Retriever,Dog" to be "GoldenRetriever,Dog". I need it to only remove the space before the comma because there will be spaces after the comma that need to stay there. And there...
  5. J

    removing space in specific place

    Hey all, I have this query: =IF( ISERROR( SEARCH("&", A3) ), IF( ISERROR( SEARCH(" ", A3) ), A3, LEFT(A3,LOOKUP(2^15,FIND(" ",A3,ROW(INDIRECT("1:"&LEN(A3)))))-1)),SUBSTITUTE(A3,MID(A3,FIND(",",A3,1)+1,FIND("&",A3,1)-FIND(",",A3,1)),"")) Problem is it takes this: CATANESE,SALVATORE J & OLGA M...

Some videos you may like

This Week's Hot Topics