I need to search for special characters and regular alphanumeric characters in regular text and in equations.
The approach you suggested using ^ and ascii code worked for me only with regular alphanumeric characters in regular text, but not with special characters in any context.
I'm writing a paper on complex calculations of gear teeth. It is currently 39 pages long and will be about 60 pages long when finished. It has many Greek symbols and will have about 100 equations and a 75-line table when finished. About a dozen drawings will be included as .jpg pictures. So far...
Paul,
Thanks for your post. I guess I should say that I'm working in MS Word 2010, in .docx format, using equation editor 3.0.
I could not see a way to export the document from Word into an Excel file.
I opened the document in Word and copied the whole document to the clipboard, then pasted...
Guys,
Thanks very much for your replies. Paul, it had occurred to me that what you said should be possible. After gathering search results into a text file, maybe you could load them into a spreadsheet for sorting and comparison. However, the Word VBA work required is a bit above my head...
I'm writing a paper on complex calculations of gear teeth. It is currently 39 pages long and will be about 60 pages long when finished. It has many Greek symbols and will have about 100 equations and a 75-line table when finished. About a dozen drawings will be included as .jpg pictures. So...
Combo,
Your code worked like a charm - very impressive! Since I hope not to be doing this a lot, I probably won't look into a faster sort algorithm.
Phil
combo,
I had considered doing something with VBA, but thought it would be way too complicated. Your code is very elegant compared to what I would have done. I'll give it a try - thanks a million!
Attached is a very abbreviated example of my sort problem. I want to sort rows 11 through 32 based on column B.
One of the goals is to eventually move the values for parameters whose description starts with "Wheel" to column E. This would be accompanied by eliminating the words "Pinion" and...
I tried changing all references to absolute, as combo suggested - sorting still would not work. Also, sorting does not solve all my problems anyway. I'm just going to bite the bullet and grunt through it by hand.
Thanks very much for your help.
phil
Skip,
Basically, what I'm trying to do is re-arrange the fields (rows) so they are in a more logical order. The spreadsheet has been evolving for more than 15 years. If I had known at the start how large and complicated it would get, I would have been more careful and orderly from the...
Skip,
My data is organized with records in columns and fields in rows. This is needed because of the large number of fields. If organized in the conventional way - records in rows and fields in columns, the spreadsheet becomes extremely awkward to use. Of course, I'm now finding myself with...
I need to sort an Excel spreadsheet with 800+ rows. There are many cell references from one row to another: for example, the formula in cell D121 refers to cell D203. When I run the Excel sort command, the row-to-row references are not preserved. As I read up on this, everyone says this is to...
I have been using Thunderbird for many years and have been very happy with it except for the last year or so.
I have 2 computers, a 32-bit desktop at work, and a relatively new Dell 64-bit laptop. Both have Win 7 Pro. I installed Thunderbird version 2.0.0.23 (20090812) on the laptop. This is...
I'm using:
Windows 7 Pro Version 6.1 (Build 7601: Service Pack 1)
Thunderbird version 2.0.0.24 (20100228)
AT&T / Yahoo mail servers
Thunderbird and/or AT&T keep losing tracking of my login credentials for outgoing mail (but not incoming mail), which prevents me from sending mail...
Thanks ChrisHirst - I'll give it a try.
Thanks also for the wisdom in your signature.
Along those lines - "What did one frog say to the other frog?"; - "Time sure is fun when you're having flies.
This more of a user problem than a programming problem, but this forum appeared to be the best match to my problem.
I'm on Win 7 Pro, ver 6.1 (Build 7601: Service Pack 1). Win updates are enabled. I use Firefox52.0.1, (updates enabled), and Adobe Shockwave Flash 24.0 r0. For a few years...
I am running Windows 7 Pro 64-bit. My printer is a Brother MFC-6490CW.
Before I contacted Brother about this problem, I could only get one copy of a printout at a time, no matter how many copies I told any application to print. Brother said, as a work-around, I should change a setting in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.