Text to columns on a formula

P

Potatosalad2

I am trying to use text to columns on the value of a cell whose formul
is ='Raw Data'A1 .. where the value is 36/4.5 oz. I need thi
automated so that if the value in 'Raw Data'A1 changes then the text t
columns changes dynamically. Is this possible
 
C

CLR

AFAIK you can't do it with TextToColumns, but you sure can with
formulas.........
Like these......
=LEFT(A1,FIND("/",A1,1)-1)
=MID(A1,FIND("/",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3
 
Top