excel data base modification

[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 - phon
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

 

[Frank Kabel]

Hi
1. For splitting use: 'Data - Text to columns'

2. For combining data use a formula such as:
=A1 & " " & B1
after copying this formula for all rows copy this new
column and inser the values with 'Edit - Paste Special -
Values'