Hello All & Happy new Year!

Intro:
I have a rather sneaky little problem on my hands where I have member
data that I've already exported successfully as a .csv from my contact
database in Excel & formated it to import into MySQL using phpMyadmin.

The problem is I don't know Excel that well & I've only figured out a
very labor intensive way to surround values with quotation marks &
parentheses. Here's the steps I took so far:

1) Save that file as a csv, and open it in Excel.

2) Import my other data into Excel and cut and paste data into the
appropriate columns.

Here's where I'm stuck!
3) Format data to look exactly like the original data [color="Red"] by
surround *all* values with quotation marks ‘

4) I also have to get the parentheses on the first and last field, and
the semi-colon at the end.

Lastly I have to delete the first two rows (the headings and sample
data) and save the file as a comma delimited csv. whew!

Please some good soul - tell me a better way...preferrable
step-by-step!

Thanks in advance for your help!

Best.
-Jenn


--
inspireme
------------------------------------------------------------------------
inspireme's Profile: http://www.excelforum.com/member.php...o&userid=28209
View this thread: http://www.excelforum.com/showthread...hreadid=498862