Searched the forum and couldn't find anything. I have a bunch of default instruments in spotlight that bring in some numerical data as text. ( 93lbs instead of 93).
Rather than changing all of my records is there a way to strip out a string of text from a worksheet column? If I could remove 'lbs' and 'watts' and return only numerical data I would be in good shape.
Thanks!