David,

The MID function doesn't insert a space. Examine your cells very
carefully to see if there is a space where you aren't seeing it.
This would be a situation in which my CellView addin would be
helpful.

http://www.cpearson.com/excel/cellview.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"David" wrote in message
...
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!