remove space

I have a excel sheet where in Sheet 1, data start from B3 and in B3, the data are like 7, 131, 221, 222, 223, 224, 225, in a cell and in C3 and D3 a value is assigned against them, the cells are not merged. I want to separate the data 7, 131, 221, 222, 223, 224, 225 etc into individual cells in...

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...

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...

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...

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...

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...