I used text to columns in Excel delimited with hypens. I open a new copy of
Excel and now everything that I try to paste with a hypen is split across
columns!! There must be a way to stop this.

You can close excel and reopen it.

Or you can do a dummy text to columns.

Find an empty cell
Put some junk in it (like: asdf)
Then do data|text to columns
Chose delimited by
But uncheck all the options
finish up the wizard
Clear that cell.



Hamilton wrote:

I used text to columns in Excel delimited with hypens. I open a new copy of
Excel and now everything that I try to paste with a hypen is split across
columns!! There must be a way to stop this.

--

Dave Peterson

Dave,

Thank you very much. My parts list is full of hyphens, it was taking 6 key
strokes per move to overcome the Microsoft idea of helping.

"Dave Peterson" wrote:

You can close excel and reopen it.

Or you can do a dummy text to columns.

Find an empty cell
Put some junk in it (like: asdf)
Then do data|text to columns
Chose delimited by
But uncheck all the options
finish up the wizard
Clear that cell.



Hamilton wrote:

I used text to columns in Excel delimited with hypens. I open a new copy of
Excel and now everything that I try to paste with a hypen is split across
columns!! There must be a way to stop this.

--

Dave Peterson

I hate when that happens!

http://spreadsheetpage.com/index.php...ns_parameters/

--
Biff
Microsoft Excel MVP


"Hamilton" wrote in message
...
Dave,

Thank you very much. My parts list is full of hyphens, it was taking 6
key
strokes per move to overcome the Microsoft idea of helping.

"Dave Peterson" wrote:

You can close excel and reopen it.

Or you can do a dummy text to columns.

Find an empty cell
Put some junk in it (like: asdf)
Then do data|text to columns
Chose delimited by
But uncheck all the options
finish up the wizard
Clear that cell.



Hamilton wrote:

I used text to columns in Excel delimited with hypens. I open a new
copy of
Excel and now everything that I try to paste with a hypen is split
across
columns!! There must be a way to stop this.

--

Dave Peterson

Thanks again. Is this problem fixed in Office 2007??

"T. Valko" wrote:

I hate when that happens!

http://spreadsheetpage.com/index.php...ns_parameters/

--
Biff
Microsoft Excel MVP


"Hamilton" wrote in message
...
Dave,

Thank you very much. My parts list is full of hyphens, it was taking 6
key
strokes per move to overcome the Microsoft idea of helping.

"Dave Peterson" wrote:

You can close excel and reopen it.

Or you can do a dummy text to columns.

Find an empty cell
Put some junk in it (like: asdf)
Then do data|text to columns
Chose delimited by
But uncheck all the options
finish up the wizard
Clear that cell.



Hamilton wrote:

I used text to columns in Excel delimited with hypens. I open a new
copy of
Excel and now everything that I try to paste with a hypen is split
across
columns!! There must be a way to stop this.

--

Dave Peterson

I bet MS sees this as a feature, not a problem.

There are lots of times when I'm copying different data with the same layout
(same parsing rules) where this comes in handy.


Hamilton wrote:

Thanks again. Is this problem fixed in Office 2007??

"T. Valko" wrote:

I hate when that happens!

http://spreadsheetpage.com/index.php...ns_parameters/

--
Biff
Microsoft Excel MVP


"Hamilton" wrote in message
...
Dave,

Thank you very much. My parts list is full of hyphens, it was taking 6
key
strokes per move to overcome the Microsoft idea of helping.

"Dave Peterson" wrote:

You can close excel and reopen it.

Or you can do a dummy text to columns.

Find an empty cell
Put some junk in it (like: asdf)
Then do data|text to columns
Chose delimited by
But uncheck all the options
finish up the wizard
Clear that cell.



Hamilton wrote:

I used text to columns in Excel delimited with hypens. I open a new
copy of
Excel and now everything that I try to paste with a hypen is split
across
columns!! There must be a way to stop this.

--

Dave Peterson





--

Dave Peterson