Frank
My feedback
-
282 votes30 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment An error occurred while saving the comment Frank commented
From the example I see here, Excel already has this feature, but it is called "Text-to-columns" and is found under the Data in the ribbon. This function has both a fixed width and a spatial delimiter that works with commas, spaces, or other indicators. It appears to do what you want, at least from the example offered in this forum.
From the example I see here, Excel already has this feature, but it is called "Text-to-columns" and is found under the Data in the ribbon. This function has both a fixed position and a spatial delimiter that works with commas, spaces, or other indicators. It appears to do what you want, at least from the example offered in this forum.