Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toolbar addin for tabs | Excel Discussion (Misc queries) | |||
toolbar addin for tabs | Excel Discussion (Misc queries) | |||
Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Hidding Tabs | Excel Discussion (Misc queries) | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |