Cell Format

[bfraser]

Looking for a little help to change a cell that contains "17/15/13"
.
into individual cells that contain 17 15 13 respectively

 

[Nebu]

Hi:

Follow this link
https://support.office.com/en-au/ar...s-Wizard-39f7b055-6b39-4cb5-9512-13cc19b3a807

Thanks

 

[bfraser]

I don't think i explained my self well enough.
Cell A1 contains 17/15/13
I'd like cell A2=17 A3=15 A4=13
thanks for any assistance

 

[bfraser]

=LEFT($E$5,2) =MID(E5,4,2) =RIGHT(E5,2)
I'm all set. I using above formulas.

 

[Hui]

Data, Text To Columns
Delimitered
Other /
Destination: $B$1

 

[bfraser]

thanks Hui.