Hi,
In the attached file I'm having a problem the Range("AC8"). Which is for a date.
My problem is the Range specified appears to have "Spaces" between "Date Of Order" and the Date.
As mentioned this file was created by "PDF". How can I get rid of what appears to be extra spaces.
Charles
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
There may be some chars in there,
Try =trim(ac8) and see if that clears it up or VBA
Please Login or Register to view this content.
dave,
Thanks for the suggestion. However, when I tried you method it still failed.
The range does show the date only. But if you look at the formula bar it shows a drop down.
And when to click it the formula bar does show anything.
Charles
Do you want to remove the "DATE OF ORDER" TEXT ALSO?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Arkadi,
Yes.
If the data is consistent, then the position to look for is the line feed after "DATE OF ORDER"
Give this a shot:
Please Login or Register to view this content.
Last edited by Arkadi; 08-25-2016 at 03:22 PM. Reason: small correction to my explanation.
Akradi,
Thanks for your answer. I used the code and modified it for other ranges.
It now works.
Dave, thanks for you help.
Charles
Glad to hear it Charles
Please remember to mark the thread as solved? Thanks !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks