Hello
I have 2 problems here:
1=2E How do you remove all the symbols from a column?
Like, all of these: !"=A3$%^&*()_+-=3D{}[]:@~;'#<>?,./=AC`|\ 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 "=A35.99 pounds"
2=2E 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"=20
Please help.
Bookmarks