E
elaine
Hello
I have 2 problems here:
1. How do you remove all the symbols from a column?
Like, all of these: !"£$%^&*()_+-={}[]~;'#<>?,./¬`|\ without
deleting them one by one from a cell?
eg. Get "Titanic DVD Box Set" from "Titanic DVD [Box Set]"
Get only "5.99 pounds" from "£5.99 pounds"
2. How do you remove all the numbers from a cell?
eg. I only want to get the street names from a list of address:
Get only " oxford street" from "123 oxford street"
Get only "abbey road" from "2 abbey road"
Please help.
I have 2 problems here:
1. How do you remove all the symbols from a column?
Like, all of these: !"£$%^&*()_+-={}[]~;'#<>?,./¬`|\ without
deleting them one by one from a cell?
eg. Get "Titanic DVD Box Set" from "Titanic DVD [Box Set]"
Get only "5.99 pounds" from "£5.99 pounds"
2. How do you remove all the numbers from a cell?
eg. I only want to get the street names from a list of address:
Get only " oxford street" from "123 oxford street"
Get only "abbey road" from "2 abbey road"
Please help.