Urgent!!! Is this possible

[elovelace256]

I have a spreadsheet with row 1 as my header allof the other rows i need

exported to a file in the format below. This is critical and any help
is
greatly appreciated

This is my spreadsheet layout. But there could be up to 8000 rows:
c_last_name c_first_name c_middle_name c_userid
Ables Donna F
donna.ables
Lovelace Eric
eric.lovelace

I need to export this to a file in this format. Each row needs to be
enclosed in ( ) and each field in that row needs to be in " " with a
comma
seperating each field.
( "ables" ,"donna" , "f" ,"donna.ables" )
( "lovelace" ,"eric" , "" ,"eric.lovelace" )


Thanks a million

 

[Fred Smith]

I would create the data in one column, using a formula like:

="( """&lower(a2)&""" ,"""&lower(b2)&""" , """&lower(c2)&"""
,"""&lower(d2)&""" )"

You could do this on a separate sheet, or on the original sheet and hide all
the other columns. Then save the file (presumably as type TXT).

 

[Dave O]

Assuming your data appears in columns A, B, C, and D, then you can
create a formula that looks like this:
="(" & char(34) & A2 & char(34)& "," & char(34) & B2 & char(34)& ","
& char(34) & C2 & char(34)& "," & char(34) & D2 & char(34)& ")"

Char(34) creates a quote mark in the output. You can then save the
appropriate section of data as a text file, or copy it into the
clipboard and paste it into MS Notepad, for instance.

Let us know if you need anything more!

Dave O