title: PowerQuery: Force Lowercase for an alphanumeric Text
body: <p>How are you able to force an alphanumeric string to lowercase (or uppercase) in powerQuery?</p>
  <p>I have a series of attribute codes coming into powerQuery , but the codes contain variations of
  upper case and lower case text. In practice these items would be considered duplicates, but PowerQuery is case sensitive. I've tried using Text.lower / Text.upper but this requires the data to be type text. My data is alphanumeric (123abc, 111, aaa) and text functions do not work for data <em>type any</em></p>
  <p>Suggestions?
  description below:</p>
  <pre><code>' Activity       Activity ID'
  
    Apple          1CA11
    Apple          1ca11
    Orange         2dp23
    Orange         2DP23
  
  'This should become: 
    Apple          1ca11
    Orange         2dp23
  </code></pre>
  <p>Picture below:
  <a href="https://i.stack.imgur.com/xcYBK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xcYBK.png" alt="Error Example using Text.lower" /></a></p>
  <p><a href="https://i.stack.imgur.com/LmjNO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LmjNO.png" alt="Removing Duplicates" /></a></p>