ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   tab delimited file convert to columns (https://www.excelbanter.com/excel-discussion-misc-queries/83738-tab-delimited-file-convert-columns.html)

1coach9

tab delimited file convert to columns
 

Does anyone know if excel will convert a tab-delimited file to a
columnar file that can be sorted and edited? Help!!!:confused:


--
1coach9
------------------------------------------------------------------------
1coach9's Profile: http://www.excelforum.com/member.php...o&userid=33597
View this thread: http://www.excelforum.com/showthread...hreadid=533752


blakrapter

tab delimited file convert to columns
 

It is really easy. Just go to datatext to columns and follow the
instructions. Hope that helped


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=533752



All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com