Replace Value 2016 with 16 but withhin a text string

[Dan80]

Hi, I am working in power query and need to transform some data within a column, the question appears simple enough:

Where there is 2016 replace with 16. 

However, 2016 is in the middle of a random text string and so Replace values doesn't work as it is looking up 2016 the number.  Anyone know a work around?  Thanks,

dan

[radpir · Accepted solution]

hi,

try adding a custom column:

= Text.Replace([YOUR TEXT COLUMN NAME HERE], "2016", "16")

please note that this will replace all occurances of the 2016 within the text which is or is not what you may want.

regards,

radpir

[v-qiuyu-msft · Accepted solution]

Hi @Dan80,

You can also open Query Editor, then use Replace Values feature:

Best Regards,
Qiuyun Yu

[radpir · Accepted solution]

hi,

try adding a custom column:

= Text.Replace([YOUR TEXT COLUMN NAME HERE], "2016", "16")

please note that this will replace all occurances of the 2016 within the text which is or is not what you may want.

regards,

radpir