Convert an Excel file into a text file.

[Prasad Vanka]

Hi,

I have an excel sheet with 6 columns. For example the first row looks
as:
USAN1 C1111111111 100 Reason1 January 2002

I want a simple and easy way to convert this excel file into a text
file so that the above row changes to:
USAN1#C1111111111#100#Reason1#January#2002

Thanks & Regards,
Prasad Vanka

 

[JulieD]

Hi Prasad

you can concatenate the columns into a single column and then export the new
column only
in G1 (assuming your data in A1:F1)
type
=A1&"#"&B1&"#"&C1&"#"&D1&"E1&"#"&F1
copy down as many lines as necessary

now select column G and copy it
keep column G selected and choose edit / paste special - values
you can now delete columns A to F
and use file / save as / and change the type to text (*.txt)

hope this helps
Cheers
JulieD
PS please do this on a copy of your workbook.