Split Data

[Abhijeet]

I have data in excel i want split the text & Numbers.I have mention in excel

 

[NARAYANK991]

Hi Abhijeet ,

1. Will the text always consist of just one character ?

2. Will that one character be either S or X ?

Narayan

 

[Abhijeet]

one character always S & X both

 

[NARAYANK991]

Hi Abhijeet ,

Confusing ; what do you mean by S & X both ?

Will it be either S or X or can you have data such as S7.5X or SX6 or 5XS ?

Narayan

 

[Abhijeet]

no one time only S Or X not both in same time

 

[Somendra Misra]

Hi Abhijeet,

See your file, yellow cells has formula in them.

Regards,

 

[Abhijeet]

Please give me Split the Text & Numbers your solution if S & X letter then this work & please give me Macro for split the Text & Numbers