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
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
Hi,
it very simple just use below code
![]()
Please Login or Register to view this content.
Happy to Help
VISHA
Click *, if the suggestion helps you!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>> "Mark your thread as Solved"
you can use
function =trim(A1)
or
macro
![]()
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
use trim() function
Regards,
abdul
drag the formula down, or copy the formula down in all the cells...or upload the file we will do the same for you...
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![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks