Please help me to solve my problem. I want to remove the extra space of every cell but its too many to do it one by one.
Thanks.
Moderator's note: Moved from Hello...Introduce Yourself --6StringJazzer
Please help me to solve my problem. I want to remove the extra space of every cell but its too many to do it one by one.
Thanks.
Moderator's note: Moved from Hello...Introduce Yourself --6StringJazzer
Last edited by 6StringJazzer; 03-01-2014 at 03:42 PM.
Could you post an example?
maybe TRIM() function will help here.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Try CTRL-H, Replace What: (Just press spacebar), Replace with
leave blank), and press replace all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks