Excel filter data
Budget: $10 – $30 USD
I have a unique sentence assigned to column A and B in excel.
Column A has
“My name is bob!”
Column B has
“Bob is great!”
First of all, each row in column A and B are linked together.
I want someone to use functions to filter those two sentences as such:
1. Remove all the punctuation and special chat for the sentence
2. If greater column A row 1 I’d greater than certain length, remove from list (if removed, also removed associated column B row 1.
3.for each cleaned up row of data, break the sentence into individual word and store it as such in a different column:
My, name, is, bob
My name, name is, is bob
My name is, name is bob
Bob, is, great
Bob is, is great
Bob is great
Column A has
“My name is bob!”
Column B has
“Bob is great!”
First of all, each row in column A and B are linked together.
I want someone to use functions to filter those two sentences as such:
1. Remove all the punctuation and special chat for the sentence
2. If greater column A row 1 I’d greater than certain length, remove from list (if removed, also removed associated column B row 1.
3.for each cleaned up row of data, break the sentence into individual word and store it as such in a different column:
My, name, is, bob
My name, name is, is bob
My name is, name is bob
Bob, is, great
Bob is, is great
Bob is great