PDF file into EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I split the info. from one cell into other cells? ie:
If one cell contains:
467 287-611-X35 Stone Bear Microfibre Trousers (PRE-NEW 9-12) £6.99 £3.49 *

and I want it to look like:

467 1 cell
287-611-x35 another cell
etc...
I have a full page of info. to sort into cells,
CAN ANYONE HELP?????
 
How do I split the info. from one cell into other cells? ie:
If one cell contains:
467 287-611-X35 Stone Bear Microfibre Trousers (PRE-NEW 9-12) £6.99 £3.49 *

and I want it to look like:

467 1 cell
287-611-x35 another cell
etc...
I have a full page of info. to sort into cells,
CAN ANYONE HELP?????
Click to expand...

Are all the fields the same width?

In other words, would the first cell always be three columns, the
second cell always be 11 numbers?

If so, go Data --> Text to Columns and select Fixed Width

Put a break in columns 4 and 16, etc..

MP-
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

organizing data imported via xml 1
How to give a string of data into different columns 8
Seperating information in a cell 9
Insert multiple .dat files into one pdf without losing color of their graphs 0
Inserting a picture or chart into one cell in Excel 1
Macro to match / reconcile data : One to Many 1
copying from pdf into excel ? 2
Need to link excel "cell" to a pre saved PDF file?? How do I do th 1

Back
Top