Removing 2 extra spaces in front of dates in imported excel doc
Are you sure that they are spaces, CHAR(32) which is ASCII32 or CHAR(160),
ASCII160 which looks like a space but isnt?
If one of the the entries from your report were in A1, try
=CODE(A1) and see if it returns 32 or 160
If it returns 160, highlight the whole sheet and go 'Find and replace' In
Replace what, hold down the ALT key and enter 0160, (nothing will show in th
box), leave 'Replace with' blank and hit 'Replace All'
Regards,
Alan.
"Hannah" wrote in message
...
I export a report from a customer on the web. Their worksheet contains a
delivery schedule that I must compare to my schedule. I need to use a
formula
to calculate the 20th day prior to their on dock date. The dates on their
worksheet have 2 additional unneeded spaces in the beginning of the date
(in
each cell). I need to remove these spaces in order to format the cells and
then use a formula. I have tried everything from "Find & Replace" to
retyping
each individual date. (There are about 2000 dates on this report).
Please help!
|