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

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!

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

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!

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

Thank YOu - that was exactly the solution!

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

"Stefi" wrote:

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!