MS Excel / VBA help thread

You are reading a single comment by @ChainBreaker and its replies. Click here to read the full conversation.

•

duncs

today I learned...

there's a CLEAN function...
removes non printable characters

Try that. =CLEAN(A1)

•

ChainBreaker in reply to @duncs
Try that. =CLEAN(A1)

Borked
Working date changes to like 44230
Borked give me the 03/03/2015

1 Attachment

•

Chalfie in reply to @ChainBreaker

one of those is text.
you'll need to:
if(istext(a1)+0 =0, a1, bigformulatochopoutthedatefromtextgoeshere)

About

Avatar for ChainBreaker @ChainBreaker started