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 |
#2
|
|||
|
|||
Use MID:
=MID(C2,FIND("(",C2)+1,255) -----Original Message----- 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 . |
#3
|
|||
|
|||
Thanks so much that worked perfectly!
"Bob Umlas Excel MVP" wrote: Use MID: =MID(C2,FIND("(",C2)+1,255) -----Original Message----- 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 . |
Reply |
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 |