![]() ![]() If no slash, safe to assume no fraction?ĭoing a 2nd reply in case you saw the first and wouldn't know to look for an edit. If we have a slash in there, we've got a fraction. Otherwise, safe to assume 0 (zero) inches? Same for the inches marker (the double-quote-mark). ![]() I'm wanting to see what you're seeing because I have (another) sneakin'suspicion that what you'll be typing won't always have feet in it, perhaps won't always have inches in it, and likely won't always have a fractional-piece in it.įor example, will you always have the feet marker in there (the single-quote-mark in other words)? Can I assume if it's there, we have feet to calculate, and if it's not there, we're safe to assume 0 (zero) feet? That adds some complications to the mix because we'll have to check the cell to make sure what / which elements exist before we can extract them on-the-fly and be able to calculate them accordingly.Ĭan you work up some sort of mock-up and take a screenshot of the various types of input you'll be working with? I had a sneakin'suspicion that's what you were looking for (and for the reason you referenced hehe). ![]() They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Or use tableit, or the ExcelToReddit converter (thanks to u/tirlibibi17), to convert your data into a Reddit table. Provide some dataĪdd screenshots in your text post, or provide links to uploaded images at an image-hosting site. Tip: For VBA or Power Query, select the code, press Tab, then copy/paste the selection into your post or comment. The best way to display code on Reddit is to put it in a code-block This awards the user a ClippyPoint and changes the post flair to solved. OPs may (and should) reply to any solutions saying: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |