Excel Automatic Formatting Issue

[Jakila2]

I'm having a bit of an issue with Excel. At my office, I need to take a large amount of raw data and put it into a certain format. I'm very new to macros, but I went ahead and wrote two macros that should fix most of my problems.

However, now I find that I have a strange new problem.

When I open a new Excel workbook, it leaves the raw data exactly as I paste it --- which is exactly what I want it to do, since I have to run the macro to format it properly. For some reason, though, once I created the macro, every time I paste the raw data into the workbook now, it automatically does "Text to Columns" with tab/space delimiters without even asking me.

The end result is that I can't run my macros because Excel puts the data in a format I can't work with. Why is Excel automatically doing this? Is there a way to make it stop?

I want the data to be in completely raw format, like this:

*ACCT** *PIN* ****EIN***** *****DUNS***** ********Organization Name********
U012P 8556 1371320188A2 806715629 STATE OF ILLINOIS
HHS-REG: 05 STATE: IL PMT: Warehousing STOP: N MAN-REV: N 272: File GROUP: F43K USER: xxxxx xxxxx
T/C* ***DEBIT** **POSTED** ******AMOUNT****** *DATE**SCHED* **CONFIRM*
927 10/02/2009 10/01/2009 4,455,485.00 091001 103440 4033016391
09INC-FMAP 4,455,485.00
REQUESTED BY: Xxxx Xxxxx PHONE: 202-555-8307 EMAIL: [email protected]
R224-DT: CALL-DT: 10/01/2009 DUE-DT: 10/02/2009 EST_DSB: 4,455,485.00
CREATED-BY: JIMCRAMER90 EST_COH: .00

PIN:8556 ACC:U012P 4,455,485.00 Total Advances Listed Pay Hits: 1
101,945,514,523.00 Total Advances Pay Count: 6276
09INC-FMAP 4,455,485.00 Total Subacct Advances Listed
-------------------------------------------------------

[DonkeyOte]

Once finished with TtC you need to re-run the TtC feature again this time de-activating those options you chose the last time you ran it (specifically space delimiter) - irritating isn't it !

[Cheeky Charlie]

See here for a macro (finds first empty cell and run "unlimited" ttc on that cell).

http://www.ozgrid.com/forum/showthread.php?t=82598

HTH

[Jakila2]

Once finished with TtC you need to re-run the TtC feature again this time de-activating those options you chose the last time you ran it (specifically space delimiter) - irritating isn't it !

Ahhh ... thanks. That worked!