Forum Discussion
replace function changes the format of the cell
The replace function is changing the format of cells in certain situations. I have a cell that is formatted as text and contains the value "01-2000 " (3 spaces at the end) It is a code and no...
Try it with this formula and then copy/paste
=TRIM(TEXT())
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Thanks, I was able to use the trim function to accomplish what I want to do. However, I am just puzzled as to why the replace function changes the format type of the cell.
M.