Thread
:
Need a Function to Remove Text
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,718
Need a Function to Remove Text
=LEFT(A1,FIND("-",A1)-1)
"pemmert" wrote:
Is there a function (or other Excel ability) to remove, in a single cell,
text after a certain character such as "-" e.g. to return "US" for
"US-AF-MIL" or "dot" for "dot-com"?
Reply With Quote
Teethless mama
View Public Profile
Find all posts by Teethless mama