.txt to excel
 

I have a text file, tab delimited (i think)
When i open this file in Excel all the "fields" are in one collumn.
I would like each "field" in different collumns.

Any sugestions?
Thanks :)


--
pmarques
------------------------------------------------------------------------
pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=550292

.txt to excel
 

under the data menu go to text to columns..
--
paul

remove nospam for email addy!



"pmarques" wrote:


I have a text file, tab delimited (i think)
When i open this file in Excel all the "fields" are in one collumn.
I would like each "field" in different collumns.

Any sugestions?
Thanks :)


--
pmarques
------------------------------------------------------------------------
pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=550292

.txt to excel
 

Thanks thats it
:) :)


--
pmarques
------------------------------------------------------------------------
pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=550292