What function or combination of functions would I use to get rid of all text after a space in a row?
I have rows in which I want to pull only the beginning text then get rid of everything after the space that follows this text. I know I can get the information with the SGET function but since the text at the beginning of each row is various lengths, I will end up with information I do not need. There will always be a space following the beginning text. James Belisle
