This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have this sequence in a cell, 45245E 10 9, I trim the cell and then copy and paste into another cell. As soon as I delete the spaces in between the characters, it turns into "4.5245E+113"?
In another sequence, I do the same exact exercise with 45245E AJ 8, and it turns into 45245EAJ8. I want this to happen to the above but it wont.
What is happening?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
With a value such as 45245E 10 9 in A1. the formula
=SUBSTITUTE(A1, " ", "")
will return 45245E109 as a text value.
Anyway to do this with a formula? Where I want to remove the spaces in the cell and then keep it as text and not scientific annotation.
Thanks in advance for your help.
W
The single E in the first example causes Excel to convert the value to a number in scientific notation,
To prevent this, either format the cells as Text before entering the data, or prefix the values with an apostrophe: '45245E109.
The apostrophe will be displayed in the formula bar, but not in the cells.