New Member
February 29, 2012
I had one query in using the IF as explained in the Blog. After loading the attached excel file comprising sales number using Power Query, if Column 1 has contents (Text and numbers both i.e. Store name at the beginning followed by numbers and again store name followed by numbers) and if we want to fill only text below it wherever the numbers are present until you reach a text. I tried using t[Image Can Not Be Found]he above guidelines, but could not. Could you please guide?
Thank you,
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Hi Arvind,
Try this formula in a new custom column:
if (try Number.From([Column3]) otherwise "Text") ="Text" then "Text Found" else null
You can replace "Text Found" with [Column3] if you want to return the text found.
(columns 1 and 2 are empty, I assume you are referring to column 3 instead of column 1 in your description)
Cheers,
Catalin
1 Guest(s)