ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   separating fields (https://www.excelbanter.com/charts-charting-excel/58101-separating-fields.html)

Risa

separating fields
 
I've been using Quark Express to do a layout of roster/directory, and I want
to tansfer all the info I have in there to an Excel spreadsheet. Quark Techs
told me that I would have to cut and paste everything; which I've done. Now,
I want to seperate lines 1 - 6 in to separate fields (i.e. last names in
column a, first names in column b, street address in column c, city/state/zip
in column d, and so on). How can I do this?

Greg Wilson

separating fields
 
You are better off posting to Excel.Programming instead of here. Your request
is more suited to programming and this NG has much less of a following.

We need to see some sample text and also advise us as to how many rows and
columns it pastes to. I for one am not familiar with Quark Express.

Regards,
Greg


"Risa" wrote:

I've been using Quark Express to do a layout of roster/directory, and I want
to tansfer all the info I have in there to an Excel spreadsheet. Quark Techs
told me that I would have to cut and paste everything; which I've done. Now,
I want to seperate lines 1 - 6 in to separate fields (i.e. last names in
column a, first names in column b, street address in column c, city/state/zip
in column d, and so on). How can I do this?



All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com