![]() IMPTEXT is an Excel VBA Function that will convert string text of Imperial lengths (see above) or a decimal number of inches to formatted text of Feet and Inches.ĭivisor is the 2nd parameter, its optional defaulting to 8 for 8ths of an inch. Negative numbers can be denoted with either a dash on the far left side or enclosing the entire string inside parentheses (). It handles both English and Spanish words, abbreviations and symbols for yards, feet and inches.ĭashes are treated like they are spaces, and so it just does not care where dashes are used or not, except a dash on the far left side is considered as a negative number. Here, we created a user function through this code Which will help us to convert string to long and will work like any other function in Excel.STR2INCHES is an Excel VBA Function that will convert string text for Imperial length measurements to a decimal number of Inches.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |