I'm a beginner in R and am looking for some help in either Excel or R.

I have an excel sheet with two columns (all text).

* Column1 has around 100,000 rows and is a list of lengthy names.
* Column2 has around 500 rows and is a list of shortened names.

**The requirement:** if a cell in Column1 contains any of the text strings in Column2, I need to rename the cell in Column1 to the string from Column2. All of the strings from Column2 are unique, so there shouldn't be an issue in overlap.

I couldn't figure it out in Excel because the cells aren't exact matches and Excel's approximate match was too inaccurate to use. I considered doing it in R, but the columns have different numbers of rows, which left me stumped. Would greatly appreciate any help possible. Please let me know if I should include more/additional details. Thank you!

This is an example of the format in R (except the columns are separate dfs because of the different number of rows)

```
Column1 <- data.frame(Full_Name = c("Geico Auto Insurance",
                  "Geico Motorcycle Insurance",
                  "Geico Commercial Auto Insurance",
                  "State Farm Car Insurance",
                  "State Farm Life Insurance"))
Column2 <- data.frame(Group_Name = c("Geico ",
                                 "State Farm",
                                 "Allstate"))

```

More: [what the example looks like in excel](https://i.stack.imgur.com/qXdGj.png)