Text to Column from 1 Cell to Rows

[hardeep.kanwar]

Dear All,

I have Data around 30k Min. In 1 Cell, says A1 with Delimited

Now, i want to Extract these Data in Column B1,B2,B3 so on.......

My data is Numbers , Like 95868/95689/98458/98589/95878

Is it Possible?

 

[Robert Mika]

Does your number string have 5 digit only?

Excel Workbook
	A	B	C
1	95868/95689/98458/98589/95878/26666/	*	95868
2	*	*	95689
3	*	*	98458
4	*	*	98589
5	*	*	95878
6	*	*	26666
Sheet1

 

[RichardMGreen]

Why not use the "Text-to-Columns" option in Excel 2007?
You can specify your own delimiter.

 

[Robert Mika]

Why not use the "Text-to-Columns" option in Excel 2007?
You can specify your own delimiter.

With 30K , a rather impossible

 

[RichardMGreen]

Are you talking about 30k records or 30k fields (or both)?

 

[hardeep.kanwar]

Are you talking about 30k records or 30k fields (or both)?

Yes, Its 30,000 Data

 

[hardeep.kanwar]

Does your number string have 5 digit only?

Excel Workbook
	A	B	C
1	95868/95689/98458/98589/95878/26666/	*	95868
2	*	*	95689
3	*	*	98458
4	*	*	98589
5	*	*	95878
6	*	*	26666
Sheet1

yes, and Thanks Mika

Is it Possible with Macro

Sorry but, Formula is too Long

 

[Robert Mika]

30k is not much

Sorry but VBA is not my strength

 

[RichardMGreen]

Agreed, even 30k records (rows) would no take long for Excel to sort out.