Delete everything after a certain character?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Chris,
=MID(A2,SEARCH("(",A2)+1,LEN(A2))
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Chris said:
Anyone have a formula or vb code that will delete everything from cell A1
Click to expand...
after a certain character (ie "(" ) and populate cell B1 with what remains?
 
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 said:
Anyone have a formula or vb code that will delete everything from cell A1
Click to expand...
after a certain character (ie "(" ) and populate cell B1 with what remains?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete numeric characters in a cell with alpha numeric char 1
Macro that will insert a simple text string in top cell of text file 1
Using code to insert different formulas 3
Deleting backslashs and everything after 3
Deleting characters after 3rd occurence of a string 4
how do I delete all text before or after a symbol? 5
How to check if a certain function is used 2
Delete 1st character if string is longer than 6 characters 3

Back
Top