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?