Power Query | Insert a character to a string

[ovetteabejuela]

Is there a way to insert a character into a string, for example I'm working with a time which is in HHMM format

so I want 0730 to become 07:30 or 0915 to become 09:15.

The solution I have right now is to split the text into 2 and then merge with the colon in between.

[v-yulgu-msft · Accepted solution]

Hi @ovetteabejuela,

Add a custom column via Text.Insert function.

= Table.AddColumn(Source, "Custom2", each Text.Insert(Text.From([Column1]),2,":"))

Best regards,

Yuliana Gu