excel data base

[dee markou]

hi there.

i need some help please guys.

i have exported some names & telephone numbers from a software packag
(sms centre) & im trying 2import them in2 a package called e-txt. thes
packages reads csv files.

ive encountered a problem my exported files r saved in excel lik
this...

name country code area code phone number
joe bloggs 44 07977 797898

but the e-txt database fields r as follows
1st name surname phone number
joe bloggs 447977797898

how do i convert the fields???
i need 2 split field (name) in2 (1st name) & (surname) & then combin
(country code), (area code) & (phone number) in2 (phone number).

is this possible???
i have over 500 contacts, so i cant do this manually.

thanks 4 readin my message, i really hope this all makes sence 2some1.

yours hopefully

dee:confused

 

[Lady Layla]

For the phone problem you can enter in E2 (presuming data starts in A2 and CC
is B2 AC is C2 and PN is D2) =B2&C2&E2 Copy down for all rows

For the name problem, highlight the column with the name in it, Go to Data -
Text to columns, Deliminated using space Ok


: hi there.
:
: i need some help please guys.
:
: i have exported some names & telephone numbers from a software package
: (sms centre) & im trying 2import them in2 a package called e-txt. these
: packages reads csv files.
:
: ive encountered a problem my exported files r saved in excel like
: this...
:
: name country code area code phone number
: joe bloggs 44 07977 797898
:
: but the e-txt database fields r as follows
: 1st name surname phone number
: joe bloggs 447977797898
:
: how do i convert the fields???
: i need 2 split field (name) in2 (1st name) & (surname) & then combine
: (country code), (area code) & (phone number) in2 (phone number).
:
: is this possible???
: i have over 500 contacts, so i cant do this manually.
:
: thanks 4 readin my message, i really hope this all makes sence 2some1.
:
: yours hopefully
:
: dee
:
:
: ---
: Message posted
:

 

[Frank Kabel]

Hi
see your other post
P.S.: please don't multipost