View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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