| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete everything after a certain character?
Anyone have a formula or vb code that will delete everything from cell A1 after a certain character (ie "(" ) and populate cell B1 with what remains?
TIA -Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete everything after a certain character?
Chris,
=MID(A2,SEARCH("(",A2)+1,LEN(A2)) -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Chris" wrote in message ... Anyone have a formula or vb code that will delete everything from cell A1 after a certain character (ie "(" ) and populate cell B1 with what remains? TIA -Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete everything after a certain character?
Chris,
In code you can use Instr(1, str1, str 2) to locate you character. And inbed this in a Left(str 1, Instr()-1) to get your string. Range("A2") = Left(Range("A1"), InStr(1, Range("A1"), "(") - 1) hth -- steveb (Remove 'NoSpam' from email address if replying direct) "Chris" wrote in message ... Anyone have a formula or vb code that will delete everything from cell A1 after a certain character (ie "(" ) and populate cell B1 with what remains? TIA -Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete special character | Excel Discussion (Misc queries) | |||
| How to remove (delete) the first Character in all of the columns | Excel Discussion (Misc queries) | |||
| How do I delete the last character in a field in Excell? | New Users to Excel | |||
| Delete all occurrences of a character | New Users to Excel | |||
| Delete Asc(10) character from cell | Excel Programming | |||
Linear Mode
