Recent content by mrfritz44

Thank you Sir!

Our Internal Audit department once had a slide rule that calulated the percentage of certainty for data validaiton over a given sample. I cannot for the life of me find and equation to use for my own validation. Does anyone have that equation or could you point me in the right direction for...

We have a prescription report at work that was designed to print two columns. For the Detail section, the "Format with Multiple Columns" is checked. As an aside, the right side of the report is shaded blue and can't be edited. We also have a special printer that prints single prescriptions so...

Thank you very much Gavin. That last function is the ticket and the one I'll be using. Have a good one, Fred

Update....that funciton works but there seems to be a character limit on the cell for the macro to work. I trimmed down the text block a bit and then it works. There seems to be a limit around 600 charcters that makes it not work. This is too bad since it seems like a very useful macro if I...

Using this macro with no luck: Sub RemoveParagraphs() Cells.Replace What:=Chr(10), Replacement:=" ", LookAt:=xlPart, SearchOrder:= _ xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False End Sub

It's a chr(10), which I already tried in the previous replacement macro...........ahhhhhhhh!!!!!!!!!!!

This is the block of text: Note that the following scripts will take a long time to run as they read the entire Anc file! Script to identify ANC records with error #08 "Ev-Subject Error, null not allowed" select where EV-PTR = 0 OR EV-PTR = 8224; l d @prikey, ev-use, ev-ptr, ev-date;go...

I highlight the cell and then run the macro. IS this what you mean? Similar funcitons work for text typed into Excel, but not the copy and pasted block. Fred

Thank you for the attempt, but it did not work. Try pasting the text I listed above on your funciton. It appears to do nothing. Thanks, Fred

I want to remove everything necessary to make the text appear like the block I manually edited above. This text is all in one cell. I'm not sure what characters are keeping the lines from formatting. I tried chr(9), chr(10), & chr(12). Any ideas? Fred

Sorry for being vague. The goal is to make the above text block appear as I've pasted below: Note that the following scripts will take a long time to run as they read the entire Anc file! Script to identify ANC records with error #08 "Ev-Subject Error, null not allowed" select where EV-PTR = 0...

I actually got it to run, but it won't work with the block of text I'm trying to clean. I'll post the text block here and maybe you can deduce what modifications needs to be made to the macro? Thanks, Fred Here's the text block: Note that the following scripts will take a long time to run...

Thanks very much for the tip. From a newbie perspective, how do I get this code into Excel to actually use as you described? Thank you! Fred

I would like to start with a blank spreadsheet that uses some technique (macro, function?) to automatically remove spaces from a cell when text is pasted into it. Better yet, I would want to remove instances of double-spaces with nothing. The goal is to automate the process of forming a...