ADITYAKANWAR
11-18-2016, 03:05 AM
Dear Experts
I am stuck in excel and need the help, on a daily basis we have received the Payment Details file from accounts dept. I am also attaching the file, it has lots of hidden spaces :crying:, which are not removed even using trim function, and find and replace procedure and we have to removed manually :banghead:
One of my friend using ASAP utilities, it's very fast and useful, but unfortunately, we can't download this software in my office due to security reasons
Is it possible to removed these hidden spaces
Thanks in Advance
Aditya Kanwar
I am stuck in excel and need the help, on a daily basis we have received the Payment Details file from accounts dept. I am also attaching the file, it has lots of hidden spaces :crying:, which are not removed even using trim function, and find and replace procedure and we have to removed manually :banghead:
One of my friend using ASAP utilities, it's very fast and useful, but unfortunately, we can't download this software in my office due to security reasons
Is it possible to removed these hidden spaces
Thanks in Advance
Aditya Kanwar