Can you take several digits from 1 cell and put them in individual cells

[Jack-P-Winner]

I want to take the square roots of numbers 0-9 and put each digit in an individual cell. I am curious if this can be done with a formula. I have other sets to do this with too

 

[Muhammad Shakeel Ishaq]

HI Jack,

i suggest you to use text to column fixed width

 

[NARAYANK991]

Hi Larry ,

See if this is OK.

Narayan

 

[Khalid NGO]

Hi Jack,

I have used Sir Luke's formula
=IF(LEN($J$6)<COLUMNS($A$1:C$1),"",MID($J$6,COLUMNS($A$1:C$1),1))

 

[Khalid NGO]

File also attached...

 

[Jack-P-Winner]

perfect, Thank you!!