I've pawed through every HELP screen in Calc and can't find a way
to do this.
I have these imported CSV files - (imported into Calc, of course)
they have two fields, both with nothing but text in the cells. They are
(1) email name (2) email address. What I need to do is globally insert,
for the first column, open and close quotes, and for the second column,
open and close arrow brackets.
Graphically, here's what I have:
John Doe [EMAIL PROTECTED]
Here's the result I need:
"John Doe" <[EMAIL PROTECTED]>
Can Calc get me there? I have not yet found the means of doing so.
Thanks,
Brewster Gillett
--
******************************************************************
W. Brewster Gillett [EMAIL PROTECTED] Portland, OR USA
******************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
