Tag Archives: Technology

Cool Excel formula for replacing line breaks

If you copy and paste from another application into Excel, chances are you’ll come across some boxes that create unsightly line breaks in your cells. Use this formula to make those line breaks disappear: =SUBSTITUTE(SUBSTITUTE([celladdress],CHAR(13),” “),CHAR(10),”") where [celladdress] is the … Continue reading

Posted in Excel, Microsoft | Tagged , | 1 Comment

Xobni Outlook search

The inability to find things inside of that inscrutable black inbox that is your Microsoft Outlook email is one of the great frustrations of modern life. So Xobni’s search tool seemed like a great thing. And it probably is, if … Continue reading

Posted in Technology | Tagged | Comments Off

Find and replace for fixed width text in Microsoft Word

If you have rows of fixed-width data (in this case the first 12 characters of each row) and you want to put a tab at the end, put this in your “Find what” box in Microsoft Word: (^13*{12}) and put … Continue reading

Posted in Microsoft, Regular Expressions | Tagged , | Comments Off

CD burning problem solved

My CD problems turned out not to be a root kit, virus, or OS issue. Just hardware. Bought a new burner for $22 from newegg and everything’s good as new.

Posted in Technology | Tagged | Comments Off