segreegate one cell in to multiple cells for given conditions

[nitinmb]

Dear All ,

I have following values in xls -
1) 1250X2360
2)12X23551
3) 33334X21
ETC.

I want to segreegate above values from single cell to differt cells as per below
Output
Numbers left to "X"n one column , "X" another column , Numbers right to "X"n one column
1) 1250 , x , 2360
2)12, X, 23551
3)33334 , X ,21

Please do the needful.

[avk]

Suppose your data in "A2"
In "B2" :

Please Login or Register  to view this content.

In "C2" :

Please Login or Register  to view this content.