Is there a way to crop text in an Excel cell?

C

cochranrg

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?
 
J

JCM

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

cochranrg

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
 
W

wjohnson

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

cochranrg

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
 
Top