Proper Capitalization only before delimiter

Question

Hello,&nbsp;[I wrote this question out and forgot about it. Here is the solution. Since I was already concatenating two columns I just added a bit to the M function.]&nbsp;= Text.Combine({Text.Proper([City]),[State]},", ")My data looks something like this:&nbsp;CityState:&nbsp;Portland, ORPORTLAND, ORSeattle, WASEATTLE, WALOS ANGELES, CALos Angeles, CA&nbsp;I would like it all to follow "proper" capitalization for the City but maintain the state abbreviations as capitalized as follows&nbsp;Portland, ORPortland, ORSeattle, WASeattle, WALos Angeles, CALos Angeles, CA&nbsp;None of the standard formatting options seem to work as "Capitalize Each Word" results with "OR" as "Or" and "WA" as "Wa" etc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Replying to myself just to mark this as solved.&nbsp;= Text.Combine({Text.Proper([City]),[State]},", ")&nbsp;Text.Proper is what did the trick.&nbsp;

Forum Discussion

Proper Capitalization only before delimiter

1 Reply

Related content

Escape row delimiter within quotes

decompress, skip lines, delimit

Proper duration counting

Capitalize only first word

First letter capitalized