Converting excel to notepad
 

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!!!
--
Cindy

Converting excel to notepad
 

Can't you use
datatext to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cindy" wrote in message
...
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!!!
--
Cindy

Converting excel to notepad
 

How exactly do i do that?
--
Cindy


"Don Guillett" wrote:

Can't you use
datatext to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cindy" wrote in message
...
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!!!
--
Cindy

Converting excel to notepad
 

On your menu toolbar there should be an entry labeled Data
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cindy" wrote in message
...
How exactly do i do that?
--
Cindy


"Don Guillett" wrote:

Can't you use
datatext to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cindy" wrote in message
...
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!!!
--
Cindy