Hi René,
René Drewes wrote:
Hello,
after importing telephone numbers from a csv file, leading zeros are
lost. How can i avoid this?
In the csv import dialog (where you specify whether the file is comma or
tab separated and such) you can click on the header for each column and
choose the data type. If you choose text for the phone number column it
will be imported verbatim.
Further i would like to combine two fields from a csv file (which is
first and last name) into one field (which is only name).
I've got 300 data sets and do not want to do it by hand for each one.
Any suggestions for automation?
Temporarily insert a third column.
=A1&" "&B1 (for the columns containing first and last names)
Replicate down the column.
Select that column, Cntl-C to copy to clipboard.
With that column still selected, Edit -> Paste Special. Untick every box
except "Strings". OK. That will replace the formula with the literal
string resulting from the formula.
Now you can delete the original first and last name columns.
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
