software

I have a column of text, a description of my products) some have
characters up to say 500. My problem is I am uploading this spreadsheet
in to a program that limits the description column to 250 characters in
1 colum.I can use up to 4 column. Is there any formula that would allow
me to take the column with 500 characters and divide it in to 2 and
place the text in 2 columns? Since I have over 30,000 products it would
be very time sensitive doing them one at a time.For text in A1, in B1 enter:
=LEFT(A1,LEN(A1)/2)In C1 enter:
=RIGHT(A1,LEN(A1)-LEN(A1)/2)--
Gary's Studentquot; wrote:

gt; I have a column of text, a description of my products) some have
gt; characters up to say 500. My problem is I am uploading this spreadsheet
gt; in to a program that limits the description column to 250 characters in
gt; 1 colum.I can use up to 4 column. Is there any formula that would allow
gt; me to take the column with 500 characters and divide it in to 2 and
gt; place the text in 2 columns? Since I have over 30,000 products it would
gt; be very time sensitive doing them one at a time.
gt;
gt;

Very clever.......so simple, yet so effective.......a keeper!Vaya con Dios,
Chuck, CABGx3
quot;Gary''s Studentquot; wrote:

gt; For text in A1, in B1 enter:
gt; =LEFT(A1,LEN(A1)/2)
gt;
gt;
gt; In C1 enter:
gt; =RIGHT(A1,LEN(A1)-LEN(A1)/2)
gt;
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; I have a column of text, a description of my products) some have
gt; gt; characters up to say 500. My problem is I am uploading this spreadsheet
gt; gt; in to a program that limits the description column to 250 characters in
gt; gt; 1 colum.I can use up to 4 column. Is there any formula that would allow
gt; gt; me to take the column with 500 characters and divide it in to 2 and
gt; gt; place the text in 2 columns? Since I have over 30,000 products it would
gt; gt; be very time sensitive doing them one at a time.
gt; gt;
gt; gt;

Thank You very much , this will help me immensly!You are very welcome!
--
Gary's Studentquot; wrote:

gt; Thank You very much , this will help me immensly!
gt;
gt;

Another question if you don't mind, on that same coloumn, is it
possible to drop a line of text, I addedquot;Shipping charges will apply
to orders under $100.00quot; and I want to remove it from all the items, as
I said I have 30,000 items, is it possible.Hi Pete,
You must have a very huge monitor.
I think you'd be better off to format the column with wrap
after loading up your worksheet.

Select column, Format, Cells, Alignment (tab), Wrap Text

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

gt; wrote in message oups.com...
gt; I have a column of text, a description of my products) some have
gt; characters up to say 500. My problem is I am uploading this spreadsheet
gt; in to a program that limits the description column to 250 characters in
gt; 1 colum.I can use up to 4 column. Is there any formula that would allow
gt; me to take the column with 500 characters and divide it in to 2 and
gt; place the text in 2 columns? Since I have over 30,000 products it would
gt; be very time sensitive doing them one at a time.
gt;
Hi Pete,
Okay maybe it makes more sense when included in this thread
(as opposed to the same post somewhere else).
I take it that you simply want to remove the text quot;Shipping charges will....quot;
from every cell in a column. Simply select the column and then
use the short cut Ctrl H fill in the top with your string
and don't put anything into the replace with.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

gt; wrote in message oups.com...
gt; Another question if you don't mind, on that same coloumn, is it
gt; possible to drop a line of text, I addedquot;Shipping charges will apply
gt; to orders under $100.00quot; and I want to remove it from all the items, as
gt; I said I have 30,000 items, is it possible.
gt;