How can I seperate numbers from text (in one cell) into 2 cells?

[LinLin]

Hi Everyone

I have data in this form in ONE CELL

20040 - Selling Expenses

I would like this data in TWO cells:

[ 20040 ] [ - Selling Expenses ]

Is there anyway to do this for a lot of cells?

I use Vlookup a lot and Find/Replace and I imagine it could be done with
wild characters maybe (?) but I do not have enough experience for this kind
of search.
Any suggestions appreciated!
thanks!

 

[Stefi]

Select cells you want to split up and use Data->Text to columns!
Regards,
Stefi


„LinLin†ezt írta:

 

[LinLin]

Thank YOu - that was exactly the solution!

(nagyon szépen köszönöm - my mother is Hungarian!)

Select cells you want to split up and use Data->Text to columns!
Regards,
Stefi


„LinLin†ezt írta:

Hi Everyone

I have data in this form in ONE CELL

20040 - Selling Expenses

I would like this data in TWO cells:

[ 20040 ] [ - Selling Expenses ]

Is there anyway to do this for a lot of cells?

I use Vlookup a lot and Find/Replace and I imagine it could be done with
wild characters maybe (?) but I do not have enough experience for this kind
of search.
Any suggestions appreciated!
thanks!