separatate
 

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 "," or ";"?


--
erik550
------------------------------------------------------------------------
erik550's Profile: http://www.excelforum.com/member.php...o&userid=32086
View this thread: http://www.excelforum.com/showthread...hreadid=526039

separatate
 

If 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:

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 "," or ";"?

--
erik550
------------------------------------------------------------------------
erik550's Profile: http://www.excelforum.com/member.php...o&userid=32086
View this thread: http://www.excelforum.com/showthread...hreadid=526039

--

Dave Peterson