Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text to column
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
I think this will work, but can you be more specific as to how i should do
it. here is the text in A1: 34.00 20.00 ABC 1.06 + 1.00 308,885 21.00 20.49 20.50 -0.40 20.30 20.50 thats all in one line though. so i need it to be separated into 12 columns. the length and format are always the same. "John Wood" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to Column effecting automatically | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions |