Recent content by philrock

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.

Thanks Andy

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...

No upload Skip, sorry

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...

Thanks very much ChrisHirst, this helps a lot Frog wisdom - time sure is fun when you're having flies