| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extra string before a specific character
I have a column of data, like CA-, THAMES-, AWR-. etc. I want to pull all
data before the "-". It could be 2 characters to 6. Any ideas? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extra string before a specific character
Try this:
=LEFT(A1,FIND("-",A1)-1) assuming your test is in A1, then copy down as required. Hope this helps. Pete On Feb 11, 1:39*pm, Sandra wrote: I have a column of data, like CA-, THAMES-, AWR-. etc. *I want to pull all data before the "-". *It could be 2 characters to 6. *Any ideas? *Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting specific character in text string | Excel Worksheet Functions | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| check if the text string start with a specific character | New Users to Excel | |||
| Changing a specific character type in text string | Excel Discussion (Misc queries) | |||
| Extra Character in cell | Excel Worksheet Functions | |||
Linear Mode
