LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default Same Text Characters, 2 Different Codes

I extracted two columns of data from SAP, one from the MARA table and one
from MARC (figured this might help if you use SAP). The 2nd table was a
subset of ther first. My goal was to find the elements in the first set that
were missing from the sub-set.

I created column A with the super-set and column B with the subset. I ran a
matching argument and got no matches. I took the data into Access and got no
matches. I'm looking at the two columns and I can plainly see matches.

Then I ran a CODE function and it turns out that the value "B" in column A
was = to 66 but the value for "B" in the adjacent column was = to 9. I typed
a "B" in the third column and it had a code value of 66.

Now I've compared extractions from SAP, using Excel worksheets for over a
year now and this is the first time I've run into it. Does anyone have any
idea why this would occur? (I realize it might be an "SAP thing" but thought
I would ask anyway.

Thanks,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Leading 0s in zip codes suppressed - should be text or zip format Foolish Aunt Excel Discussion (Misc queries) 2 September 6th 07 04:08 PM
need help converting text codes to names scats Excel Worksheet Functions 4 November 14th 06 04:32 AM
Searching for codes in text strings Bhupinder Rayat Excel Worksheet Functions 9 April 27th 06 01:20 PM
Finding 13 character codes in text strings Bhupinder Rayat Excel Worksheet Functions 2 April 25th 06 05:14 PM
zip codes not being saved as text in CSV format MelissaM Excel Discussion (Misc queries) 5 September 9th 05 11:10 PM


All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"