Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text to Column effecting automatically
Hi,
Let's say I copy following text from some ASCII file and paste in to excel. Wer-67843-PLOU Qty-34r5-ASDE Then I use Excel's text to column feature on above and parse it with Hyphen as delimter. Wer 67843 PLOU Qty 34r5 ASDE Well and Good. Next time I copy text with similar structure from ASCII file and paste in to the ABOVE excel SESSION the parsing happens automatically. Now, sometimes I would like this to happen automatically while sometimes not (In the second case I have to go to the trouble of starting new excel sessions). Can this be feature be toggled on or off at user's whims? Did MS DESIGN this auto parsing feature with a definite purpose? Regards, Hari India |
#2
|
|||
|
|||
It doesn't work that way for me in Excel 2000. The TextToColumns feature
only affects the values I apply it to at the time, no residual action here.........which version of Excel are you using? Vaya con Dios, Chuck, CABGx3 "Hari" wrote in message oups.com... Hi, Let's say I copy following text from some ASCII file and paste in to excel. Wer-67843-PLOU Qty-34r5-ASDE Then I use Excel's text to column feature on above and parse it with Hyphen as delimter. Wer 67843 PLOU Qty 34r5 ASDE Well and Good. Next time I copy text with similar structure from ASCII file and paste in to the ABOVE excel SESSION the parsing happens automatically. Now, sometimes I would like this to happen automatically while sometimes not (In the second case I have to go to the trouble of starting new excel sessions). Can this be feature be toggled on or off at user's whims? Did MS DESIGN this auto parsing feature with a definite purpose? Regards, Hari India |
#3
|
|||
|
|||
Hi Vaya,
I have tried it in 2002 and 2003. It works the way I said it. (Win XP as OS). Regards Hari India |
#4
|
|||
|
|||
Hi Hari...........
Hmmmm..........well, I don't use either XL02, XL03 or WinXP, so I can't check it out there, but perhaps someone else can jump in here and try it on their system..........sorry, and Good Luck finding the problem. I'll be watching this thread for the solution because my company may upgrade someday, and if this is a built in bug, I would like to know about it. Vaya con Dios, Chuck, CABGx3 "Hari" wrote in message oups.com... Hi Vaya, I have tried it in 2002 and 2003. It works the way I said it. (Win XP as OS). Regards Hari India |
#5
|
|||
|
|||
I think that this was designed as a feature (my guess only).
If you do this a lot in the same session and always use the same parsing rules, then it makes life a bit easier. To "clear" excel's memory, you can close excel and reopen it. Or you could do a dummy data|text to columns. choose delimited and uncheck all the delimiters. and finish up. Hari wrote: Hi, Let's say I copy following text from some ASCII file and paste in to excel. Wer-67843-PLOU Qty-34r5-ASDE Then I use Excel's text to column feature on above and parse it with Hyphen as delimter. Wer 67843 PLOU Qty 34r5 ASDE Well and Good. Next time I copy text with similar structure from ASCII file and paste in to the ABOVE excel SESSION the parsing happens automatically. Now, sometimes I would like this to happen automatically while sometimes not (In the second case I have to go to the trouble of starting new excel sessions). Can this be feature be toggled on or off at user's whims? Did MS DESIGN this auto parsing feature with a definite purpose? Regards, Hari India -- Dave Peterson |
#6
|
|||
|
|||
Try this macro (posted by another user some time ago). I've got mine
assigned to a custom button on my toolbar. Sub TextToColumnsReset() Dim DeleteCell As Boolean If ActiveCell = "" Then ActiveCell = 1 DeleteCell = True End If ActiveCell.TextToColumns DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _ Tab:=False, Semicolon:=False, Comma:=False, Space:=False, _ Other:=False If DeleteCell Then ActiveCell.ClearContents End Sub |
#7
|
|||
|
|||
Hi Dave and Paul,
Thnx for your comments and solution. Regards, Hari India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Search column and move text formula | Excel Discussion (Misc queries) | |||
Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
Is there a way I can enter a letter to proceed text a column of ce | Excel Discussion (Misc queries) | |||
Splitting text in one column into two (or more) columns. | Excel Worksheet Functions |