just coz your info is confidential doest mean you couldnt post an example of a few cells deleting everything except the last and first letters
martin
wilson
becomes
n
w
"3.0 Schedule
C submitted the work progress chart as of end of 2.
(Appendix)
P advised C that ng
the that
productivity areas.
According O, date
of 02.
This not
be progress
improves immediately.
C intend to
do time
resolves chedule."
is that any use??? just deleted txt in between.. but the start and ends sud be the same
i understand what ur saying with that code..
but never used VBE immediate window before..
can ya give me a quick run down with it??
We can not use anything you post as we have not idea what the copy/paste and post would have done to the text.
Can you not copy 1 example to a new workbook and simply replace all the visible characters with X.
To go to VBE press ALT+F11
to goto immediate window press CTRL+G
copy/paste the line of syntax and press ENTER on that line.
OH MY GOD...
that does exactly what i want..
probably pushing the boat out a bit now..
but is there a way i can get that to work globably on the whole program??
You could try this in the immediate window
cells.Replace chr(10)," "
A MILLION THANKS YOU..
thank you thank you.. i think you just saved me about 3 weeks work there...
just as a question , have you saved the workbook first? replace alt+010 only works if the data has been saved in a work book
you can't just open one stick in a load of data then use it.
ye.. all the data saved 1st.. so its ok that way..
You can use the CLEAN function, which removes all non-printable characters.
This worked well for me.
@xaver, please try to avoid posting to old threads - this thread for example has been dormant for over two years.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks