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
|