Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract word before /
Hello I want to extract the word or words before the " /" example the
cell reads University of Texas/TX so I need to extract University of Texas . I tried right and left functions but it does not work. the cells always has the name of the university then / initials of the state thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract word before /
=search("/",a1)
will give you the position of the slash. So =left(a1,search("/",a1)-1) will give you the stuff before the slash. If there's a chance that you don't have slashes in the data, you could use: =left(a1,search("/",a1&"/")-1) It'll avoid the error. Wanna Learn wrote: Hello I want to extract the word or words before the " /" example the cell reads University of Texas/TX so I need to extract University of Texas . I tried right and left functions but it does not work. the cells always has the name of the university then / initials of the state thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract word before /
How about this?
=LEFT(A2,FIND("/",A2)-1) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Wanna Learn" wrote: Hello I want to extract the word or words before the " /" example the cell reads University of Texas/TX so I need to extract University of Texas . I tried right and left functions but it does not work. the cells always has the name of the university then / initials of the state thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract word before /
hi
if the cells always has the name of the university then / initials of the state, try text to columns using the back slash as a delimiter. on the 03 menu bardatatext to columnsfollow the wizard. Regards FSt1 "Wanna Learn" wrote: Hello I want to extract the word or words before the " /" example the cell reads University of Texas/TX so I need to extract University of Texas . I tried right and left functions but it does not work. the cells always has the name of the university then / initials of the state thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Acronym (Extract first letter of each word) | Excel Worksheet Functions | |||
How to extract right-most word? | Excel Worksheet Functions | |||
extract word function | Excel Worksheet Functions | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
Extract the first word from a cell? | Excel Discussion (Misc queries) |