Solved: Re: If statement

Warren10976 · ‎10-12-2021

Hi,

I am new to power query. Can someone please assist me with an IF statement that can copy text values (names of people) from column with (names and amounts) text to a new column.

The if statement should be able to test if the value is a text, if the condition is yes then copy the value to the next column, if no then blank.

Thank you

Watsky · ‎10-12-2021

Hey @Warren10976 ,

Try this in Power Query. This will extract all text within a value.

= Table.AddColumn(#"Changed Type", "Text Values", each Text.Select([Values],{"a".."z","A".."Z"}),type text)

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

View solution in original post

Watsky · ‎10-12-2021

Hey @Warren10976 ,

Try this in Power Query. This will extract all text within a value.

= Table.AddColumn(#"Changed Type", "Text Values", each Text.Select([Values],{"a".."z","A".."Z"}),type text)

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!