=ISBLANK (Text Error

[sammymalta]

Good afternoon

I have the following data

20181101
20181101
20181101
20181101
20181101
20181102
20181105
20181105

and in another col I am using the formula =TEXT(RIGHT(L2,2)&"/"&MID(L2,5,2)&"/"&LEFT(L2,4),"DD/MM/YYYY") to get the date...in a correct format.

However, if L2 is empty, the'/' are coming up and i want the to return a blank cell. I tried 'ISblank' but it isnt working.. is there any other method?

Thanks
Sam

[than_gold]

Hello Sam,
try this IF..

Please Login or Register  to view this content.

[sammymalta]

Oh i'm such an idiot... so simple. Thanks alot.

[than_gold]

You welcome!!!