Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Seperating buy Tabs

Hello All,
I have some info that is only seperated by commas not in tabs to columns, is
there a way to put it into tabs/columns? I know I can save as tab deleted put
I have no idea how to put it back into tab/columns!!!

Also is there somewhere where I can redownload Excel? It came on my computer
and I did not receive discs for it so I can't reinstalle it if that is the
problem!! AWW

Thanks All!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default Seperating buy Tabs

Select the cells that have the comma-separated data, then use the menu to
choose

Data-Text-to columns

and follow the prompts, choosing Delimited as the data type and comma as the
separator

"Txgrl" wrote:

Hello All,
I have some info that is only seperated by commas not in tabs to columns, is
there a way to put it into tabs/columns? I know I can save as tab deleted put
I have no idea how to put it back into tab/columns!!!

Also is there somewhere where I can redownload Excel? It came on my computer
and I did not receive discs for it so I can't reinstalle it if that is the
problem!! AWW

Thanks All!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Seperating buy Tabs

Hey Duke,
Ok I tried that but it did not work. All the info downlaoded into colimn A,
it looks like this "Txgrl,texas,email address, #" you get the picture! I
highlited column A and did what you said but it did not change anything.

Do I need to do something else or is my Excel program bad?
Thanks again!

"Duke Carey" wrote:

Select the cells that have the comma-separated data, then use the menu to
choose

Data-Text-to columns

and follow the prompts, choosing Delimited as the data type and comma as the
separator

"Txgrl" wrote:

Hello All,
I have some info that is only seperated by commas not in tabs to columns, is
there a way to put it into tabs/columns? I know I can save as tab deleted put
I have no idea how to put it back into tab/columns!!!

Also is there somewhere where I can redownload Excel? It came on my computer
and I did not receive discs for it so I can't reinstalle it if that is the
problem!! AWW

Thanks All!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default Seperating buy Tabs

I'd be very surprised if your Excel app is bad.

Is there any data to the right of column A, and were you asked if you wanted
to overwrite that data? If you were asked, and if you responded "no," then
nothing happens

If that didn't happen, did you at least get a chance to walk through the
Convert Text to Columns Wizard? Did it suggest to you that it was going to
split the text where it should?


"Txgrl" wrote:

Hey Duke,
Ok I tried that but it did not work. All the info downlaoded into colimn A,
it looks like this "Txgrl,texas,email address, #" you get the picture! I
highlited column A and did what you said but it did not change anything.

Do I need to do something else or is my Excel program bad?
Thanks again!

"Duke Carey" wrote:

Select the cells that have the comma-separated data, then use the menu to
choose

Data-Text-to columns

and follow the prompts, choosing Delimited as the data type and comma as the
separator

"Txgrl" wrote:

Hello All,
I have some info that is only seperated by commas not in tabs to columns, is
there a way to put it into tabs/columns? I know I can save as tab deleted put
I have no idea how to put it back into tab/columns!!!

Also is there somewhere where I can redownload Excel? It came on my computer
and I did not receive discs for it so I can't reinstalle it if that is the
problem!! AWW

Thanks All!

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Seperating buy Tabs

Hey Duke,
It working! I figured it out!!! I deleted the top few I had manualy changed,
but I got it all together!! Thank you so much!!!!!

"Duke Carey" wrote:

I'd be very surprised if your Excel app is bad.

Is there any data to the right of column A, and were you asked if you wanted
to overwrite that data? If you were asked, and if you responded "no," then
nothing happens

If that didn't happen, did you at least get a chance to walk through the
Convert Text to Columns Wizard? Did it suggest to you that it was going to
split the text where it should?


"Txgrl" wrote:

Hey Duke,
Ok I tried that but it did not work. All the info downlaoded into colimn A,
it looks like this "Txgrl,texas,email address, #" you get the picture! I
highlited column A and did what you said but it did not change anything.

Do I need to do something else or is my Excel program bad?
Thanks again!

"Duke Carey" wrote:

Select the cells that have the comma-separated data, then use the menu to
choose

Data-Text-to columns

and follow the prompts, choosing Delimited as the data type and comma as the
separator

"Txgrl" wrote:

Hello All,
I have some info that is only seperated by commas not in tabs to columns, is
there a way to put it into tabs/columns? I know I can save as tab deleted put
I have no idea how to put it back into tab/columns!!!

Also is there somewhere where I can redownload Excel? It came on my computer
and I did not receive discs for it so I can't reinstalle it if that is the
problem!! AWW

Thanks All!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
toolbar addin for tabs BorisS Excel Discussion (Misc queries) 0 November 29th 06 04:43 PM
toolbar addin for tabs Mike Rogers Excel Discussion (Misc queries) 0 November 29th 06 03:52 PM
Tabs accross of bottom of sheet are not showing robert Excel Discussion (Misc queries) 3 April 22nd 05 09:29 PM
Hidding Tabs Aviator Excel Discussion (Misc queries) 1 December 15th 04 04:55 PM
Sheet tabs disappear sometimes in Internet Explorer Jan Nordgreen Excel Discussion (Misc queries) 0 December 6th 04 01:34 AM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"