Solved: Splitting cell values into two defferent columns

[rahullambe]

Hi Friends,

I have name of the employees and their code# in one cell with space. I want to split this name and code# on two different Cell.:help

[mdmackillop]

Use Data/Text to Columns

[rahullambe]

Thanks,

The data contains more than 1000 rows

[rahullambe]

can you suggest me any other option than text to column?

[rahullambe]

10114
Attached is the file...
where I want to split the name and code# except using text to columns:help

Thanks.
Please help me!

[rahullambe]

its very urgent for me

I am trying to Split it but I can not do that....

[Bob Phillips]

What's wrong with Text To Columns?

[rahullambe]

That is ma assignment for MBA exams and there is condition that I can not use text to column function.

[jfournier]

why not use formulas in excel?

With your full text in cell c1:
'name cell
=LEFT(C1,FIND(" ",C1))
'code num cell
=RIGHT(C1,LEN(C1)-FIND(" ",C1))

[Bob Phillips]

Sorry, but we don't do homework. What value is your MBA if we make the effort?

[rahullambe]

Thanks J Fournier Thanks for your help

Its Solved.

[jfournier]

Sorry didn't see that it was homework. This stuff isn't very hard, maybe I should go get an MBA if this is as bad as it gets

[rahullambe]

J Fournier its a sample part of an MBA its not a homework its just an assignments, and I have already completed 85% work I was stucked with the same formulae.

Well, Thanks for your help
Thanks a lot!

[mdmackillop]

there is condition that I can not use text to column function.
So why not state this in your question?

See FAQ re homework.