and I want to be able to sort this while sorting Column A so it stays together. I have multiple columns on this spreadsheet that have two columns that are attached. This is a guess. I don't think Excelread 49816-1631 as a number. That is to say, it's NOT a number, not until y...
Here is picture of my spreadsheet. One column is the dollar amount the other column is an invoice number and I need the invoice number in numerical order so I highlight the 2 columns under the vendor to sort by the invoice number. Northeastern Refrigeration OP Aquatics The Plumbing Source Ri...
{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1741011909471","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","...
{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1741365408602","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","...
Turn it into a numeric value IFERROR(NUMBERVALUE(LEFT([@Data];FIND("-";[@Data])-1));[@Data]) If there is no minus FIND will generate an error. If so, return the value as is Column D and E are optional depending on your need. ...
lxj190Sort by the numeric column but look at the alphanumeric..? ...or turn the column into text format making the numbers treated as strings. Menu Home: Number: lxj190Right- if the invoice number not always begins numeric, then it will not work as proposed. ...
","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1740549332456,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1740549332456,"...
{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1741360647000","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","...
As I said, it's a guess, but a semi-informed one. If you'd care to post the spreadsheet, or a portion of it, we can test my hypothesis. mathetesHi. You will have to interpret the part before the minus sign as numeric.
This works on a range of data. What I want is a toggle button in Excel configuration that turns off the standard Excel functionality of removing leading zeros from alphanumeric, imported data. Leading ZEROs are an exceptionally used Cell format is not the default one also,,, so considering ...