Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text to column
Hi, I have a bunch of files that I have extract data from everyday. However, I need to use the "text to column" function before I could sort the file. I would like to create a macro to help me do the job so then I don't have to do it everyday. Is it possible to write a "text to column" macro? if so, how can I do that? Please let me know. Thank you very much. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=517635 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text to column
Hi Owl.
Try turning on the macro recorder as you perform the required operations. The resultant code may be edited to enable more general use. If you experience problems with this editing, post back with details. --- Regards, Norman "owl527" wrote in message ... Hi, I have a bunch of files that I have extract data from everyday. However, I need to use the "text to column" function before I could sort the file. I would like to create a macro to help me do the job so then I don't have to do it everyday. Is it possible to write a "text to column" macro? if so, how can I do that? Please let me know. Thank you very much. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=517635 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
How to subtract one text column based on their text column MS xls. | Excel Discussion (Misc queries) | |||
Find a text from a column in a text string within another column? | New Users to Excel | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) |