How do I rename some of my data inputs?

[klaraklara]

How do I make my dataset such that all items called "Shoe and boxes" are labeled "Shoes and boxes" instead?   

In other words such that the first table becomes the second table?

I have tried several if formulas, but without luck. I am a real newbie, and appreciate your kind help! :)

Item	Price
Trouser	100
Shoes and boxes	30
shoe and boxes	10
Jeans	100
Top	90
Shoe and boxes	30

Item	Price
Trouser	100
Shoes and boxes	30
Shoes and boxes	10
Jeans	100
Top	90
Shoes and boxes	30

[JohnJPS · Accepted solution]

Will the following formula work:

IIF([Item]=="shoe and boxes","Shoes and boxes",[Item])

[Kenda]

Hey @klaraklara! 

Are these the only combinations of shoes/shoe and boxes in your whole data set? If so, you can add a formula with the following expression:

iif([Item]="shoe and boxes" || [Item]="Shoe and boxes", "Shoes and boxes",[Item])

[BenMoss]

If you have many such cases I tend to favour a lookup table, which you can perform a join on to return the true value for each item.

Another option, which probably isn't a good place to start as a newbie is the 'fuzzy match' tool which has great capability to match objects that are similar in name.

Ben

[Kenda]

@klaraklara yet another option, very similar to what @BenMoss said, would be to use a Find Replace tool.

[klaraklara]

Thank you  so much! it was very helpful!

[bmmunoz]

How would you type the formula in if there are multiple combinations?