New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Insert text anywhere in a cell without adding a new column using the Power Query’s UI

There are no Insert functions ( that I know of) in the power query user interface, so if you don’t know M, you probably have to create a new column to insert text in power query.
In today’s video, I will show you how you can use power query user interface, to insert text into a column without adding a new column and using only one step.

*NOTE: this works for inserting text anywhere inside a record or value or cell.

Table of contents:

00:00 Intro & use case
00:35 Do it creating a new column
01:30 Do it again in one step

Watch the tutorial:

Insert text anywhere in a cell without adding a new column using the Power Query User Interface.
Was this helpful?
Previous Change field types in one step in Power Query
Next How to extract text with an if condition in one step in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents