Every now and then you come across something that Excel doesn’t have a function for which requires you to get fancy and figure out some tricky way to get the job done. While coding up a solution in ...

Text in an Excel cell may span several lines. For example, cells in a sheet listing employees may contain extended comments on each worker's performance. Excel controls the number of lines in such a ...

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. <BR><BR>Now I want to convert ...