Seperate 1 cell in to 2

[ugg]

Good morning,

I have a cell that contains the value "Account Enquiry - 35". What I am wanting to do is seperate it in to 2 cells.

A1
Account Enquiry
B1
35

Is there a way that I can do this? I have a few cells that are the same. May not always be 2 numbers at the end, however there will always be " - " in the middle

[mrice]

You need to use the Text to Columns functionality that you will find in the data menu/ribbon. Use - as the delimiting character in he 'other' option.

[ugg]

Thankyou! Thats perfect