Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pulling all information right of this "("
Is there a way to just pull the information from a cell such as this?
Example: 3 WORLDS OF GULLIVER (DVD)(P&S-1.33-MONO-ENG-FR-SUB-SP-DUB) I would like to pull all this information and place it in another cell (DVD)(P&S-1.33-MONO-ENG-FR-SUB-SP-DUB) I tried this command thinking if it works with left why not with right. =right(c2,find("(",c2)) but this only pulls everything about 3-4 letters into it so i get something like this ORLDS OF GULLIVER (DVD)(P&S-1.33-MONO-ENG-FR-SUB-SP-DUB) Any help is apprecaited. I have to do this on about 45,000 different cells so it is rather a pain. THanks again for any help you can provide |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) | |||
Duplicating Cell Information | Excel Worksheet Functions | |||
Database Information | Excel Worksheet Functions | |||
Pulling parts of information from one cell and putting in another | Excel Discussion (Misc queries) | |||
Using multiple spreadsheet for different information | Setting up and Configuration of Excel |