Text to columns word and number

[mmmarks]

Hi all,

I have an query regarding splitting a data into different cells
I have a data in A coloumn like

abcd9874
cdefkhj879645
kjk78935

I want differentiate Alpha and number in other Cells. How?

Thankx in Advance

 

[Jonmo1]

Try like this

Excel Workbook
	A	B	C
1	Source	Alpha	Numeric
2	abcd9874	abcd	9874
3	cdefkhj879645	cdefkhj	879645
4	kjk78935	kjk	78935
Sheet1

Hope that helps.

 

[mmmarks]

Thankx a Lot . It's working..
But If numeric come first and Alpha come next then???

Eg : 987665abcdef

 

[Jonmo1]

Try this..

The formula in B2 must be enterd with CTRL + SHIFT + ENTER

Excel Workbook
	A	B	C
2	987665abcdef	987665	abcdef
Sheet2

 

[mmmarks]

Great Its works....
One more Question is...
I want be like You in Excel so What do I have to Do






/

 

[Jonmo1]

Great Its works....
One more Question is...
I want be like You in Excel so What do I have to Do

Glad to help, thanks for the feedback.


1. Keep reading MrExcel.Com
2. Ask Questions
3. Start trying to Answer other peoples questions. <-this will help alot.
4. Do Excel for Fun, not just work. Challenge yourself, try to make a game of some sort.

When I was starting out, I made Hangman, Yahtzee, Sudoku, and Even Chess. Chess wasn't very good though...

 

[mmmarks]

Thanks for your valuable suggestion.
I will do so...

 

[Jonmo1]

Prime Example for why Reading MrExcel.com Makes you better at Excel...

I just read this thread..
http://www.mrexcel.com/forum/showthread.php?t=567669

And discovered a MUCH better formula for B2 to extract the number in a string like
987665abcdef

From your question in Post #3.

This will be for B2, and does not require CTRL + SHIFT + ENTER
=LOOKUP(2^15,--LEFT(A2,ROW(B$1:INDEX(B:B,LEN(A2)))))

 

[Jonmo1]

That should be

=LOOKUP(9.99999999999999E+307,--LEFT(A2,ROW(B$1:INDEX(B:B,LEN(A2)))))

 

[Mangolili]

When I was starting out, I made Hangman, Yahtzee, Sudoku, and Even Chess. Chess wasn't very good though...

That's very interesting to know. I never thought of making games in excel. Will try it out as well =)