Forum Discussion

NathanUMB's avatar
NathanUMB
New Member
5 years ago
Solved

Remove Text in Integer Column

So as part of one of my trainings I am pulling the data from this website url. https://www.california-demographics.com/cities_by_population However there is new issues from the data pull. The Rank...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi NathanUMB 

    Please follow these steps:

    Open Power Query

    Select Rank and change its type to text

    You will see TIE for some cells, Select and right click on Rank Column

    Click on Replace Values and 

     

    Leave "Replace With" Blank and click OK

    Finaly re change the type of the Coloumn to Whole Number

    Voilà

     

    If you wanted to keep the TIE in the Rank column then skip the 2 last steps and keep the column as TEXT format

     

     

     

     

Pragati11's avatar
Pragati11
Super User
5 years ago

HI NathanUMB ,

 

Can you share some screenshot aroung the sample data that you are pulling?

Also a screenshot on what different values the RANK column has?

 

Thanks,

Pragati