Convert special characters

**raviexcel** · 11-19-2010, 03:26 AM

Hi,

I have a txt file which has a special characters. I use text to column option in excel to sepearte it . Is there any other easy way to copy it in the excel please.. My sample txt file is attached herewith.

regards,

ravi

**dominicb** · 11-19-2010, 03:32 AM

Good morning raviexcel

It appears ot be a .csv file.
What is the question?
Is th attached correct?

DominicB

**raviexcel** · 11-19-2010, 03:38 AM

Hi Domini,

Thanks! This what i need it. I dont know how to do it. I need also the column no C to be in the txt format since the number appers as scientific format.

Regards,

ravi

**dominicb** · 11-19-2010, 03:55 AM

Hi raviexcel

Copy your text file and paste it into Excel.
Go to Data > Text to Columns
Choose Delimited and click Next.
Make sure that only Comma is selected and select the column you want to create as text and clcik on the text button. Then click Finish.

HTH

DominicB

**raviexcel** · 11-19-2010, 04:01 AM

Hi,

I have been using the same option (Text to Column). Is there any other solutions to do it?

I know also other option that open a txt file through excel & do the same.

regards,

ravi

**dominicb** · 11-19-2010, 04:23 AM

Hi raviexcel

If you attempt to open the file in Excel you will be presented with the same wizard. I didn't save your attachment, just opened it so opted for the copying route - and also you mentioned the text to columns feature by name rather than import.

HTH

DominicB

**snb** · 11-19-2010, 05:37 AM

Sub snb()
  Open "E:\OF\a[1].txt" For Input As #1
    sq = Split(Replace(Replace(Input(LOF(1), #1), ",", ",'"), vbCrLf, vbCrLf & "'"), vbCrLf)
  Close

  For j = 0 To UBound(sq)
    Cells(j + 1, 1).Resize(, 7) = Split(sq(j), ",")
  Next
End Sub