Forum Discussion

csmathers2's avatar
csmathers2
Copper Contributor
Sep 20, 2024
Solved

TRIM() function removing date format in Excel

How do I retain a date format when using the TRIM() function in Excel? 
excel
  • deanshepherd's avatar
    deanshepherd
    Sep 20, 2024

    try this
    =--TRIM(cell)

    Regards D

deanshepherd's avatar
deanshepherd
Brass Contributor
Sep 20, 2024

try this
=--TRIM(cell)

Regards D

csmathers2's avatar
csmathers2
Copper Contributor
Sep 20, 2024
Thanks, Dean - that did the trick!

Resources