tag:blogger.com,1999:blog-3794737577784583819.post1622752264889130108..comments2023-10-25T04:38:36.360-07:00Comments on Excel Enthusiasts: Using the TEXT FunctionBob DeLaMartrehttp://www.blogger.com/profile/03761089085420930697noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3794737577784583819.post-2790774026831179682011-02-17T20:22:32.391-08:002011-02-17T20:22:32.391-08:00Bob, you should add a search this blog gizmo in th...Bob, you should add a search this blog gizmo in this blog. It is part of blogger's fields you can add.<br />Unrelated to this post, here is a trick I like: say you want to have a ROW of formulas that refer to cells of values in a COLUMN so that A1=D4, B1=D5,C1=D6, etc. In Column E, make E4=$D4, E5=$D5, E6=$D6, etc (notice the $).<br />Copy the range of cells with these formulas in column E.<br />Go to Cell A1. Paste Special. Select Transpose. Select Formulas. Hit enter. BAM! Now, from A1 to B1, etc, you have the formulas referring to the COLUMN of data that begins in D4!popuphttps://www.blogger.com/profile/06837546096934652490noreply@blogger.com