Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Space after Mid Function
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |