Text to columns on a formula
 

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


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=556547

Text to columns on a formula
 

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



"Potatosalad2" wrote:


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


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=556547