| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 110791 | 2010-07-01 23:52:00 | Excel List Help | rob_on_guitar (4196) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1115220 | 2010-07-01 23:52:00 | Hi guys, I want to copy a list from a non excel source (.xps file) to excel. The problem I have is when I select the list from the .xps file and paste to XL it shows up as one long text reading left to right in one cell. Is it possible so that if I copy and paste, (its a list of names) it can paste so each name is in a cell of its own and reads downwards? Or am I looking at manual input? Cheers guys Rob |
rob_on_guitar (4196) | ||
| 1115221 | 2010-07-01 23:57:00 | ...I thought Id post an example to show whats happening, sorry for the double post: The original list: J Bloggs P Jane T Rex When copied to XL it is going: J Bloggs P Jane T Rex I just want it the same as the original. Cheers |
rob_on_guitar (4196) | ||
| 1115222 | 2010-07-02 00:05:00 | Copy it paste as Unformatted texxt. Most of the time it works. | pctek (84) | ||
| 1115223 | 2010-07-02 00:11:00 | What version of Office are you using ? Just copied a similar xps list into excel and it listed as original (Office 2010) |
wainuitech (129) | ||
| 1115224 | 2010-07-02 00:16:00 | Using office 2007 Thanks pctek, but the text is still reading across as one line in one cell |
rob_on_guitar (4196) | ||
| 1115225 | 2010-07-02 00:30:00 | One method may to try importing into Word. Then do a search and replace space " " with a comma "," then import into Excel as a comma delimited file. If you would like me to give it a go PM me and I'll give you an Email address where you can send the original file. |
Sweep (90) | ||
| 1115226 | 2010-07-02 00:38:00 | Ill give it a shot Sweep, due to the sensitivity of the files I cant send any of it out. Just browsing the net at converters, anyone tried them? |
rob_on_guitar (4196) | ||
| 1115227 | 2010-07-02 00:51:00 | copy & paste to a text file (in notepad or equiv) Then either just open it with excel or do a data import and point it at the text file. |
fred_fish (15241) | ||
| 1115228 | 2010-07-02 01:01:00 | Magic! Thanks Fred!:thumbs: | rob_on_guitar (4196) | ||
| 1115229 | 2010-07-02 01:26:00 | Just for future reference Rob, Excel is equipped to do this with the Text To Columns function under the Data menu; it will parse (break down into constituent pieces) anything based on whatever delimiter you tell it (space, comma, pipe etc). Very handy tool!! | nofam (9009) | ||
| 1 2 | |||||