ExcelBanter - PDF file into EXCEL

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - PDF file into EXCEL (https://www.excelbanter.com/excel-worksheet-functions/36485-pdf-file-into-excel.html)

PDF file into EXCEL

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?????

On Thu, 21 Jul 2005 10:37:04 -0700, "Foxy" wrote:
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?????

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-
--
"Learning is a behavior that results from consequences."
B.F. Skinner