help with text in column

  • Thread starter Thread starter Pete.Cornejo
  • Start date Start date
P

Pete.Cornejo

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)
 
Very clever.......so simple, yet so effective.......a keeper!


Vaya con Dios,
Chuck, CABGx3
 
Another question if you don't mind, on that same coloumn, is it
possible to drop a line of text, I added"Shipping charges will apply
to orders under $100.00" 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
 
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 "Shipping charges will...."
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.
 
Back
Top