Need to find a way to crop text in an Excel column. Want to crop any text
past characters. Is there a way to do this?

I would try using the text function MID(text,start_num,num_chars) which can
"crop" any part of text you want.


"cochranrg" wrote:

Need to find a way to crop text in an Excel column. Want to crop any text
past characters. Is there a way to do this?

I've used MID in programming years ago, but don't really know how to use it
in Excel. I'll look into it, thanks for the response.

Rob

"JCM" wrote:

I would try using the text function MID(text,start_num,num_chars) which can
"crop" any part of text you want.


"cochranrg" wrote:

Need to find a way to crop text in an Excel column. Want to crop any text
past characters. Is there a way to do this?

Select the column you want to divide, then - on the menu bar go to
"Data" then select "TEXT TO COLUMNS and follow the information on the
popup window. This will work, if the text you want to "throw away" is
at approximately the same location in each cell. If you "see empty
cells" - on the pop-up window use the slider bar to scroll down until
you come to a cell with text. Then put the mouse icon where you want to
divide the column and "click." Then continue to follow the directions
on the popup window. Then delete the column you don't want.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2307698

I'll try this. I did the MID thing, but this doesn't work for what I am
trying to do (once I delete the original column of text of course my formula
doesn't work any more). What I'm doing is converting a tab deliminated file
to a csv file for internet upload. The csv file needs to be truncated to
characters per column.

Rob

"wjohnson" wrote:


Select the column you want to divide, then - on the menu bar go to
"Data" then select "TEXT TO COLUMNS and follow the information on the
popup window. This will work, if the text you want to "throw away" is
at approximately the same location in each cell. If you "see empty
cells" - on the pop-up window use the slider bar to scroll down until
you come to a cell with text. Then put the mouse icon where you want to
divide the column and "click." Then continue to follow the directions
on the popup window. Then delete the column you don't want.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2307698

"cochranrg" wrote in message
...
I'll try this. I did the MID thing, but this doesn't work for what I am
trying to do (once I delete the original column of text of course my
formula
doesn't work any more). What I'm doing is converting a tab deliminated
file
to a csv file for internet upload. The csv file needs to be truncated to
characters per column.

Rob


Select the results of your formulas and copy.
Without changing the selected area, use
Edit Paste Special Values
This replaces the formulas with their results.
You can then delete the original data.

Very cool, I will try this. Thanks!

Rob

"Stephen" wrote:

"cochranrg" wrote in message
...
I'll try this. I did the MID thing, but this doesn't work for what I am
trying to do (once I delete the original column of text of course my
formula
doesn't work any more). What I'm doing is converting a tab deliminated
file
to a csv file for internet upload. The csv file needs to be truncated to
characters per column.

Rob


Select the results of your formulas and copy.
Without changing the selected area, use
Edit Paste Special Values
This replaces the formulas with their results.
You can then delete the original data.