How to remove unknown whitespaces when splitting Excel data to multiple columns.

[NiranjanK1]

Hi All,

I have a excel data with unknown white spaces,

for one field split i have 1,

for second fields split i have 5 spaces,

for 3 field split i have 11 spaces,

how can i handle to create below image output.how to remove unknown whitespaces when splitting Excel data to multiple columns.

Thanks & Regards,

Niranjan

[NiranjanK1]

@binuacs Thanks for your valuble suggessions.