ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create automatic columns (https://www.excelbanter.com/excel-discussion-misc-queries/93198-how-do-i-create-automatic-columns.html)

Jezebella

How do I create automatic columns
 
I have created a price list of items for a company in Excel. Most of the
copy is in one column. How can I create three columns automatically. What I
have done in the past is cut and past copy into the columns but when I've
needed to insert new items or delete items I have to move everything around
manually. Thanks

Allllen

How do I create automatic columns
 
Hi Jezebella,

Can you give us just the first few lines of your price list, so we can see
what it looks like. Then I or someone else will be able to show you how to
split things up.
--
Allllen


"Jezebella" wrote:

I have created a price list of items for a company in Excel. Most of the
copy is in one column. How can I create three columns automatically. What I
have done in the past is cut and past copy into the columns but when I've
needed to insert new items or delete items I have to move everything around
manually. Thanks



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

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