Stripping Blank Characters form Imported Data

G

Greg

I am trying to verify 2 worksheets full of data. One has
been imported from Visual Basic and the other from
Business Object. The Business object sheet, brings over
the entire field not just the charaters needed. Example:
For the city field there are 50 characters available. If
you use Nashville, the Business Object brings over 50
characters where the Visual Basic brings over 9. When
trying to find descrepancies, this brings back a false
positive if the city is the same. Is there a way to
manipulate that data when it is sent to Excel?
 
D

Doug Kanter

The easiest way to deal with this would be to find out if Business Object
has a "field squeeze" option, to remove blank spaces. If not, make an
experimental copy of your worksheet, and check out the Clean function -
"Removes all nonprintable charcaters from text", or the Trim function -
"Removes all spaces from a text string except for single spaces between
words". You'll find these by putting the cursor in a cell where you want the
formula to land, and clicking Insert, Function. The functions are divided
into categories, and when you highlight one, you'll get a brief description
of the function's function!
 
G

Guest

Thanks.
-----Original Message-----
The easiest way to deal with this would be to find out if Business Object
has a "field squeeze" option, to remove blank spaces. If not, make an
experimental copy of your worksheet, and check out the Clean function -
"Removes all nonprintable charcaters from text", or the Trim function -
"Removes all spaces from a text string except for single spaces between
words". You'll find these by putting the cursor in a cell where you want the
formula to land, and clicking Insert, Function. The functions are divided
into categories, and when you highlight one, you'll get a brief description
of the function's function!




.
Click to expand...
 
Top