Converting excel to notepad

C

Cindy

Hi. I have the convert XLS program. I'm trying to convert fax numbers (area
codes included) on excel sheel to notepad with a comma to seperate the fax
numbers. Can someone please help. I get " this little sign in between and a
comma between the number and code.
this is how it is suppose to look - 0422222222, 0433333333
but this is how it looks - ["043","2222222"
Please help!!!
 
C

Cindy

How exactly do i do that?
--
Cindy


Don Guillett said:
Can't you use
data>text to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Cindy said:
Hi. I have the convert XLS program. I'm trying to convert fax numbers
(area
codes included) on excel sheel to notepad with a comma to seperate the fax
numbers. Can someone please help. I get " this little sign in between
and a
comma between the number and code.
this is how it is suppose to look - 0422222222, 0433333333
but this is how it looks - ["043","2222222"
Please help!!!
Click to expand...
Click to expand...
 
D

Don Guillett

On your menu toolbar there should be an entry labeled Data
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Cindy said:
How exactly do i do that?
--
Cindy


Don Guillett said:
Can't you use
data>text to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Cindy said:
Hi. I have the convert XLS program. I'm trying to convert fax numbers
(area
codes included) on excel sheel to notepad with a comma to seperate the
fax
numbers. Can someone please help. I get " this little sign in between
and a
comma between the number and code.
this is how it is suppose to look - 0422222222, 0433333333
but this is how it looks - ["043","2222222"
Please help!!!
Click to expand...
Click to expand...
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

Excel does not accept text format! 0
Converting list of numbers in Excel to a string of text in Word 3
Converting excel to PDF, single page converts to multiple HELP! 1
How can I copy plain text from Excel to Notepad? 5
Problem in Conversion of Excel to Text(Tab delimated) 1
Export Column Info to Words or Notepad 4
Import from Notepad delimited text 7
How to use Windows command within Excel macros 2

Top