How can I get rid of these colons

R

rock

Hi,

Here is one entry row of 7000 I have imported from a text database which
I will want to eventually export as a csv file for another database.

You will see that there is a : after every field entry.

How can I get rid of these please? I have Excel 2002

Rock


sK9R4ABb: teddals: tc7243: (e-mail address removed): Ted: Cooke: : 051217:
Members: 46 Cambridge Crescent: Bungjup: Wendlet: Alabama:
6168:00:00 USA: N/A: N/A: Over_40: : : : : ADMIN ACTIVATE
 
L

L. Howard Kittle

I used Find > Replace under Edit to remove the :'s from your example.
Replace with 'nothing'.

HTH
Regards,
Howard
 
R

rock

Thanks.. Did it!!

Regards,

rock

L. Howard Kittle said:
I used Find > Replace under Edit to remove the :'s from your example.
Replace with 'nothing'.

HTH
Regards,
Howard
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get rid of the language box? 0
How to get rid of time that comes with dates 2
how to get rid of double entries in to-do list 2
How do I get rid of "getting started with Microsoft Office Access" 3
How get rid of extraneous sheets? 5
I can't get rid of a persistent "sending message 1 of 1" message . 1
How do I get rid of a blank page from a document? 2
how do I get rid of a split screen? 2

Top