Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
For text in A1, in B1 enter:
=LEFT(A1,LEN(A1)/2) In C1 enter: =RIGHT(A1,LEN(A1)-LEN(A1)/2) -- Gary's Student " wrote: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
Very clever.......so simple, yet so effective.......a keeper!
Vaya con Dios, Chuck, CABGx3 "Gary''s Student" wrote: For text in A1, in B1 enter: =LEFT(A1,LEN(A1)/2) In C1 enter: =RIGHT(A1,LEN(A1)-LEN(A1)/2) -- Gary's Student " wrote: 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
Thank You very much , this will help me immensly!
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
You are very welcome!
-- Gary's Student " wrote: Thank You very much , this will help me immensly! |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
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: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm wrote in message oups.com... 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. |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with text in column
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. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |