07-26-2019 12:39 PM
07-26-2019 01:16 PM
07-26-2019 01:32 PM - edited 07-26-2019 02:02 PM
If you type 9 digits in cell A1 (Note that digits are right aligned) and then say in cell C1 you need the first digit only, then
in C1 type:
Copy this function to the right 8 more columns and you get the 9 digits parsed , each in a separate cell and they are still recognized as numbers (Right aligned)
Here is a screenshot of what I did
Note that using only text functions such as Right, Mid, Left,Replace, Substitute... >> returns a TEXT which is Left Aligned and cannot be reused in calculations...
Also Note that although you could split the number into multiple columns by using "Text To Column" >> it's not dynamic and if the source column expands >> You will have to repeat the process.
to regroup them you can use one of the following:
Note that All Re-grouping options will return TEXT (Left Aligned) so to Change it back to a Number (Right aligned) >> Multiply by one:
Hope That Helps
07-26-2019 01:52 PM
For the collection:
If numbers are in the column, they could be split by Data->Text to Columns with fixed width and destination into another columns.
To combine back as