software

When I paste data from for instance a word file in to excel I need to
use tab in word to get the data in separate cells. Is it possible to
declare this separator as something else, for instance quot;,quot; or quot;;quot;?--
erik550
------------------------------------------------------------------------
erik550's Profile: www.excelforum.com/member.php...oamp;userid=32086
View this thread: www.excelforum.com/showthread...hreadid=526039If you paste your text into a single column, you can select that column and do:

Data|text to columns
delimited
and choose the delimiter.

erik550 wrote:
gt;
gt; When I paste data from for instance a word file in to excel I need to
gt; use tab in word to get the data in separate cells. Is it possible to
gt; declare this separator as something else, for instance quot;,quot; or quot;;quot;?
gt;
gt; --
gt; erik550
gt; ------------------------------------------------------------------------
gt; erik550's Profile: www.excelforum.com/member.php...oamp;userid=32086
gt; View this thread: www.excelforum.com/showthread...hreadid=526039

--

Dave Peterson