ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   importing text file data into excel (https://www.excelbanter.com/excel-discussion-misc-queries/157402-importing-text-file-data-into-excel.html)

GradStudent N need

importing text file data into excel
 
When importing text file data into excel and setting delimiters there is no
option for the character that looks like this (l). Excel provides options
for comma, tab, semi-colon etc but not for that particular character, and
there is no way to insert that character in the option for other. Anyone
please help!!

Mike H

importing text file data into excel
 
Hi,

In my version of Excel (2003) using the import wizard you check 'Other' and
then type the delimeter you want.

Mike

"GradStudent N need" wrote:

When importing text file data into excel and setting delimiters there is no
option for the character that looks like this (l). Excel provides options
for comma, tab, semi-colon etc but not for that particular character, and
there is no way to insert that character in the option for other. Anyone
please help!!



All times are GMT +1. The time now is 11:55 PM.

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