Forum Discussion
Solved
TRIM text and _
Hi All, I have list of items in a table as below: LON_HOME LON_ADDRESS LON_PERSON LON_OWNER etc I want data appears in the report as: HOME ADDRESS PERSON OWNER I am u...
There can be many ways to do it.
1. In power query replace LON_ to blank.
2. You can split the column in Power query by number of delimiters as 4 as far left as possible.
There can be many ways to do it.
1. In power query replace LON_ to blank.
2. You can split the column in Power query by number of delimiters as 4 as far left as possible.