 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Seperating 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! 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 > Hello All, > I have some info that is only seperated by commas not in tabs to columns, is [quoted text clipped - 6 lines] > > Thanks All! 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! > Select the cells that have the comma-separated data, then use the menu to > choose [quoted text clipped - 14 lines] > > > > Thanks All! 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? > Hey Duke, > Ok I tried that but it did not work. All the info downlaoded into colimn A, [quoted text clipped - 22 lines] > > > > > > Thanks All! 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!!!!! > I'd be very surprised if your Excel app is bad. > [quoted text clipped - 32 lines] > > > > > > > > Thanks All! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.