OK, I don't know why I am having trouble with this.... I know what I want excel to do and what I was thinking of to get it to work. But I am having trouble getting it to do so. Currently I have =MID(N8,FIND(",",N8)+2,(LEN(N8)-FIND(",",N8))) which is simple enough.
My problem is extracting only up until the space after the comma. I was trying to use MID/FIND with the result of the above formula which creates a rather large formula, but it keeps throwing a #VALUE at me and I can't figure out the best way to do this.
Bookmarks