How to remove the blank space which is present at the end of the value in a cell

[prshnthvn]

Hello Everyone,

Can anyone let me know how to remove the blank space present at the end of the value in the cell?

I want this to happen for all the cell in the column and this should not affect the data in other columns.

I have attached an example in which for column B all the spaces present after th e Product name should be deleted.

Thanks in advance,
Prashanth

[austenr]

You cant do it that I know of. The column heading is the problem. That is what is keeping the white space at the end of the data. Essentially, you can't make the column 2 different sizes.

[paolo2504]

Use trim(cell) to elimintate leading and trialing spaces.
For example in cell D2 write formula =TRIM(B2) then autofill downwards up to D11. Then copy range D211, select B2 and do pastspecial (onlyvalue).
You can do this even by VBA.

[mdmackillop]

I you just want to make Column B narrower, wrap the text in B1 and adjust the row height to suit.

[austenr]

Malcomb,

I think she was after leaving the heading alone and trimming the values underneath, which is not possible. Yours is the best solution. And the only one that works.

[Bob Phillips]

Sorry guys, am I missing something here. The product names have trailing spaces, that is what is required to be removed is it not (for which paolo2504 gave a solution)?

[prshnthvn]

Thanks guys,

"Trim" is what i wanted.

Regards
Prashanth

[mdmackillop]

I only ckecked B11 which had no extra spaces!

[GTO]

..."Ahhh, I wonder if this filename is a clue. Watson, look up the Latin for Delete spaces..."



( a friendly tease of course)

[Bob Phillips]

I only ckecked B11 which had no extra spaces!

LOL! Sod's Law.

[prshnthvn]

..."Ahhh, I wonder if this filename is a clue. Watson, look up the Latin for Delete spaces..."



( a friendly tease of course)

I am sorry Sherlock holmes , next time i will explain my requirements much more clearly.

[mdmackillop]

..."Ahhh, I wonder if this filename is a clue. Watson, look up the Latin for Delete spaces..."



( a friendly tease of course).

That was meant for me!

[GTO]

Dear prshnthvn,

My apologies if you took any offense, but indeed, that was meant for the good Mr. MacKillop; just an affectionate jab.

I must say, I learn here even when just engaging in jest. Murphy's law would be the common expression here, but they are not exactly the same!

Murphy's Law
http://en.wikipedia.org/wiki/Sods_law
Sod's Law
http://en.wikipedia.org/wiki/Sod%27s_law

[Bob Phillips]

I must say, I learn here even when just engaging in jest.

That is what makes VBAX the best site around, you learn more than just Excel

[prshnthvn]

Dear prshnthvn,

My apologies if you took any offense, but indeed, that was meant for the good Mr. MacKillop; just an affectionate jab.

I must say, I learn here even when just engaging in jest. Murphy's law would be the common expression here, but they are not exactly the same!

Murphy's Law
http://en.wikipedia.org/wiki/Sods_law
Sod's Law
http://en.wikipedia.org/wiki/Sod%27s_law

Dear GTO,
No offense taken. Actually if you see this thread, many of them have mis-understood my question in the beginning, thats why i thought that you are telling that to me. And i did not understand the joke at the first and i actually translated "delete spaces" in to latin which is "delete tractus" which made no sense and after carefully reading your comment once again i understood you are talking to sherlock holmes watson. Its a good joke.