How do I rename some of my data inputs?

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

Preparation

Accepted answers

JohnJPS

Will the following formula work:

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

All comments

JohnJPS

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703