How to remove trailing SPACE from Cell value ?

**zerodegree** · 02-04-2013, 03:34 AM

Hi
How to remove trailing SPACE from Cell value ?

I have 15000 CELL value..i.e A1,A2,A3...A15000

I just want to remove trailing SPACES (if any) from these CELL value.

System: Office 2007

**visha_1984** · 02-04-2013, 03:40 AM

Hi,

it very simple just use below code

Please Login or Register  to view this content.

**vlady** · 02-04-2013, 03:40 AM

you can use
function =trim(A1)
or
macro

Please Login or Register  to view this content.

**abubaniyan** · 02-04-2013, 03:43 AM

use trim() function

**zerodegree** · 02-04-2013, 03:49 AM

Originally Posted by visha_1984

Hi,

it very simple just use below code

Please Login or Register  to view this content.

looks good ....but is not it just TRIMMING A1 element only. I have 15000 CELLS to trim.

Can it be done without programming ?

**abubaniyan** · 02-04-2013, 03:52 AM

drag the formula down, or copy the formula down in all the cells...or upload the file we will do the same for you...

**galvinpaddy** · 02-04-2013, 04:15 AM

Hi, can you simply highlight all the areas where you want the space removing, press ctrl+f, go to replace, in the search field press the space bar, and then click replace all?
I have to do this on some workbooks, although a much less qty. but might help