how do I remove text from a cell


Posted by Becky Pierson on December 27, 2000 8:49 AM

if a cell contains "351/555-1212 - Fax" is there a way using function to remove all but the numerical? Consider 33701-4668. How do I get rid of the -4668 using function? What would my logical statement be?



Posted by Aladin Akyurek on December 27, 2000 9:17 AM

Let

A1 have the value 33701-4668.

Then do:

B1 =MID(A1,1,FIND("-",A1,1)-1) and
C1 =RIGHT(A1,LEN(A1)-FIND("-",A1,1))

Aladin