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

Anybody out there?


I did mean what I posted: quotation marks (') and parentheses () and
yes
I do need to have commas in between all values, (outside parentheses of
course!)

BTW, I posted the sample data from excel to help you understand what I
need: http://www.inspiremedia.info/go/coming/xls_forum/
remember it's only a few row I have 3000 more after that. (the data is
a bit sqeexed together at the end).

Please let me know what you think..


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