Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I get rid of these colons
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: : Ted: Cooke: : 051217: Members: 46 Cambridge Crescent: Bungjup: Wendlet: Alabama: 6168:00:00 USA: N/A: N/A: Over_40: : : : : ADMIN ACTIVATE |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I get rid of these colons
I used Find Replace under Edit to remove the :'s from your example.
Replace with 'nothing'. HTH Regards, Howard "rock" wrote in message ... 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: : Ted: Cooke: : 051217: Members: 46 Cambridge Crescent: Bungjup: Wendlet: Alabama: 6168:00:00 USA: N/A: N/A: Over_40: : : : : ADMIN ACTIVATE |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I get rid of these colons
Thanks.. Did it!!
Regards, rock L. Howard Kittle wrote: I used Find Replace under Edit to remove the :'s from your example. Replace with 'nothing'. HTH Regards, Howard "rock" wrote in message ... 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: : Ted: Cooke: : 051217: Members: 46 Cambridge Crescent: Bungjup: Wendlet: Alabama: 6168:00:00 USA: N/A: N/A: Over_40: : : : : ADMIN ACTIVATE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Format issue, colons being substituted for decimals. | Excel Discussion (Misc queries) | |||
time entry with am/pm and no colons | Excel Discussion (Misc queries) | |||
insert colons in time automatically when input to cell | Excel Worksheet Functions |