I have a series of data w/ name extentions: ie FYPEWSQ.DMWAS FYPEWSQ.DMLOS FNMQ.MRIV FNMQ.MSAN
Is there a formula where i can remove everything after the period??
Thank you in advance for your help!