Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract within a cell
Hi:
I am looking for a function that will allow me to do the following: I have the following value in a cell Williams Sanders-IT Manager I want to extract the "name" only from the cell. Every row in this file is setup the same way....ie....I need a formula that will look "LEFT TO RIGHT" until a dash is found (-).......then give me the entire string to the LEFT of the dash (-) Can anyone suggest the function to make this happen???? Thank you Warren Phillips |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract within a cell
Try this:
=MID(A1,1,FIND("-",A1,1)-1) HTH, Elkar "WDP" wrote: Hi: I am looking for a function that will allow me to do the following: I have the following value in a cell Williams Sanders-IT Manager I want to extract the "name" only from the cell. Every row in this file is setup the same way....ie....I need a formula that will look "LEFT TO RIGHT" until a dash is found (-).......then give me the entire string to the LEFT of the dash (-) Can anyone suggest the function to make this happen???? Thank you Warren Phillips |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract within a cell
WOW!
That is just what I needed.....Thank you very much. Have a ROCKIN evening "Elkar" wrote: Try this: =MID(A1,1,FIND("-",A1,1)-1) HTH, Elkar "WDP" wrote: Hi: I am looking for a function that will allow me to do the following: I have the following value in a cell Williams Sanders-IT Manager I want to extract the "name" only from the cell. Every row in this file is setup the same way....ie....I need a formula that will look "LEFT TO RIGHT" until a dash is found (-).......then give me the entire string to the LEFT of the dash (-) Can anyone suggest the function to make this happen???? Thank you Warren Phillips |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract within a cell
Without formulas.....DataText to ColumnsDelimited byOther
Enter a hyphen and Finish. On Thu, 24 Aug 2006 16:42:02 -0700, WDP wrote: WOW! That is just what I needed.....Thank you very much. Have a ROCKIN evening "Elkar" wrote: Try this: =MID(A1,1,FIND("-",A1,1)-1) HTH, Elkar "WDP" wrote: Hi: I am looking for a function that will allow me to do the following: I have the following value in a cell Williams Sanders-IT Manager I want to extract the "name" only from the cell. Every row in this file is setup the same way....ie....I need a formula that will look "LEFT TO RIGHT" until a dash is found (-).......then give me the entire string to the LEFT of the dash (-) Can anyone suggest the function to make this happen???? Thank you Warren Phillips Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Formula to extract a phone# from a cell of text (eg classified)? | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Extract date from cell | Excel Worksheet Functions |