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:
![doc-convert-sientific-to-text-7](https://www.extendoffice.com/images/stories/doc-excel/convert-scitenfic-to-text/xdoc-convert-sientific-to-text-7.png.pagespeed.ic.4AHva_Ld1i.webp)
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:
![doc-convert-sientific-to-text-8](https://www.extendoffice.com/images/stories/doc-excel/convert-scitenfic-to-text/xdoc-convert-sientific-to-text-8.png.pagespeed.ic.ShOc8HqLDc.webp)
Note: This UPPER function: =UPPER(A1) also can help you, please apply any one as you like.
No comments:
Post a Comment