my favorite excel function is now clean()
# generalk
KevinJ of Kansas
08/29/2019, 3:25 PMmy favorite excel function is now clean()
r
Ricardo
08/29/2019, 5:27 PMI never new about this function! I was doing it by hand.... oh man. you might have just saved a major part of my sanity!!!!
Ricardo
08/29/2019, 5:28 PMby hand I mean find->replace{charIdon'twant},{nullspace}
k
KevinJ of Kansas
08/29/2019, 5:58 PMI worked on a client coming from epicor - they could not get these weird carriage returns out of their text. This formula saved my sanity.
3 Views