If your text string is always the same length and format, one clunky solution
would be to write a formula in cell B1 such as left(A1,3), then in C1
=Mid(A1,4,3), etc

John Wood

"ExcelQuestion" wrote:

I have a text file of data that i get on a daily basis and have to perform
the 'text to column' function on each time. Is there a way that i can just
place the new text data in column A and have it automatically updated
starting in, say, column C. Alternatively, if that isnt possible is there a
function i can write to extract the data from the text file myself. Example:
Text in A1
abc 123 def 456 ghi

How can i extract abc, 123, def, 456 and ghi into cells c1 through g1?