Hi friends,
I have addresses in cells which has more than 1 line. I don't want any extra space before or after any word/line.
The code is working fine if there is only one line in the cell but if there are more than 1 line it's not working as per requirement.
Any help will be highly appreciated.
Thanking you,
Sincerely,
mso3
Try
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
I can't post my code here .. I got error page ..Why?
URL: http://www.excelforum.com/editpost.p...post&p=4163620
Your Browser: Mozilla/5.0 (Windows NT 6.1; rv:38.0) Gecko/20100101 Firefox/38.0
Block ID: SQLi17
Block reason: SQL injection was detected and blocked.
Time: Sun, 16 Aug 2015 03:49:23 -0400
Server ID: cp448
Last edited by YasserKhalil; 08-16-2015 at 03:52 AM.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi Jindon,
Excellent! Perfect, It's removing all extra spacesses in all lines as per requirement.
Hi PCI,
No, it's not removing all spaces in all lines. Don't mind.
Thank you to both of you for your kind cooperation to solve the problem.
Thank you and have a nice day.
You are welcome and thanks for the rep.
Have you tested the code in post 4?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks