Hi David,

You don't tell us the content of F1 that definitely affect hte result of
MID. Nevertheless =TRIM(MID(F1,5,30)) will remove the extra space.

Regards,
Stefi


€žDavid€� ezt Ã*rta:

I am using mid and then concatenate to get the text I need for another
workbook. However, there is a space being inserted from the mid function, so
that when I use concatenate, an extra space appears. Here are the two
functions, they are in side by side columns.
=MID(F1,5,30) 'this is producing a space at the end. To test, copy the
result and paste special values.
=CONCATENATE(G1,"-",C1) is in the next column.
This is the result I get after using both:
Austin -TX 'The space is before the -

Thanks...this one I just can't figure!