!!!Stupid Text to Columns question!!!

Frans Scheepers

Board Regular
Joined
Apr 21, 2006
Messages
127
Hi There

This might be a stupid one but it has me baffeld. Why is it that when you do a text to column convertion it so happens that when you paste another set of data in the same workbook that it is automatically delimited.

I found that when I delimit a set of data using : as the delimiter and the paste another set of data that also contains : it is delimited automatically by excel.

This is anoying because I have to close Excel down after each delimit action I do to stop it from delimiting automatically.

Is there a way of stopping it from doing this?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Frans

If you goto Paste Special and select All the text to columns doesn't appear to occur.

Note I've only tested when this is done manually, not in code.
 
Upvote 0
Hi,

the only way I know is
select some data (doesn't matter what)
Text To Columns/ clear all delimiters in last box
OK
now paste your data

you could record a macro while "clearing" and assign this to a button before picking another dataset

kind regards,
Erik
 
Upvote 0
Frans

Perhaps you could give us some more information on what you are actually trying to achieve?:)
 
Upvote 0
Frans Scheepers,

This may be a stupid question but, why do you have to stop it?

Dufus
 
Upvote 0
say you have a text
aze:rty:uio
you do text to columns, delimiter is semicolon :))

next time you have
aze rty uio
aze:rty uio

Frans wants to use the space as delimiter; for the first item there is no problem, but the data of the second item are put into two columns automatically since there is a semicolon
 
Upvote 0
Frans wants to use the space as delimiter
Erik

I'm I missing something, because I can't see where Frans mentions delimiting by a space.:eek:
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top