mac XL formular help

[MUTZ]

hi all, I am not very proficient at XL but have a list of codes in a work book that
look like this 1/CCP9 ,
I need to remove all of the numbers and the forward slash , but retain the letters & numbers after the forward slash in a new column ??
can this be done ?
thanks in advance if you can help
mutz

 

[GGJstudios]

Data > Text to Columns

 

[MUTZ]

hi GGJ
thanks for the reply sorry I dont understand it ,

 

[GGJstudios]

hi GGJ
thanks for the reply sorry I dont understand it ,

Do you know how to click on the toolbar in Excel?

​

How to parse data using the Text To Columns command in Excel

 

[MUTZ]

hi GGJ,
cheers got it and it works fine cheers,

just have to apply it to 2000+ lines now

thank you