Page 2 of 2 FirstFirst 1 2
Results 11 to 12 of 12

Thread: LASTNAME FIRSTNAME Power Query Text replace

  1. #11
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,782
    Articles
    0
    Excel Version
    O365


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Much more elegant solution masterswordz, but I feel that mostr of the text shifting is unnecessary, bar the upshifting of column 2. For instance

    if [Column1]=Text.Upper([Column1]) then Text.Upper([Column1])

    only needs to be

    if [Column1]=Text.Upper([Column1]) then [Column1])

    the if test already ascertained it was upper-case.

  2. #12
    Acolyte masterswordz's Avatar
    Join Date
    Apr 2020
    Location
    Philippines
    Posts
    22
    Articles
    0
    Excel Version
    2016
    I'm just starting to learn PQ. Thanks for the advise, I'll surely remember this going forward.

Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •