Convert Scientific Notation To Text With Formulas
The following formulas also can help you to convert the list of scientific notation to text.
1. Please enter this formula: =trim(A1) into a blank cell, B1 for instance, see screenshot:

2. Then drag the fill handle over to the range that you want to apply this formula, and you will get the result as you want:

Note: This UPPER function: =UPPER(A1) also can help you, please apply any one as you like.
No comments:
Post a Comment