I have a program that sends a report to excel, however, instead of putting
the information in coulmns, it places it all in one cell with spaces. Is the
only way to get all this information into columns, cut & paste or is there an
easier way?
I have a program that sends a report to excel, however, instead of putting
the information in coulmns, it places it all in one cell with spaces. Is the
only way to get all this information into columns, cut & paste or is there an
easier way?
Try Data>Text to columns in the menu bar
--
Regards Ron de Bruin
http://www.rondebruin.nl
"frustratedwthis" <[email protected]> wrote in message
news:[email protected]...
>I have a program that sends a report to excel, however, instead of putting
> the information in coulmns, it places it all in one cell with spaces. Is the
> only way to get all this information into columns, cut & paste or is there an
> easier way?
You can parse the data:
You cannot split a cell or range (range: Two or more cells on a sheet. The
cells in a range can be adjacent or nonadjacent.) of cells that was not
previously merged. You can, however, divide the contents of unmerged cells
and display them across other cells.
1.. Select the cell, the range of cells, or the entire column that
contains the text values that you want to divide across other cells. A range
can be any number of rows tall, but no more than one column wide.
Important Unless there are one or more blank columns to the right of the
selected column, the data to the right of the selected column will be
overwritten.
2.. On the Data menu, click Text to Columns.
3.. Follow the instructions in the Convert Text to Columns Wizard to
specify how you want to divide the text into columns.
--
Dab
Cut off: yourhead to respond
"frustratedwthis" <[email protected]> wrote in
message news:[email protected]...
>I have a program that sends a report to excel, however, instead of putting
> the information in coulmns, it places it all in one cell with spaces. Is
> the
> only way to get all this information into columns, cut & paste or is there
> an
> easier way?
excellent. it worked great...thanks!
"Ron de Bruin" wrote:
> Try Data>Text to columns in the menu bar
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "frustratedwthis" <[email protected]> wrote in message
> news:[email protected]...
> >I have a program that sends a report to excel, however, instead of putting
> > the information in coulmns, it places it all in one cell with spaces. Is the
> > only way to get all this information into columns, cut & paste or is there an
> > easier way?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks