View Single Post
  #4   Report Post  
Dave R.
 
Posts: n/a
Default

You can use

=MID(A1,FIND("=",A1)+1,999999)

and you can place a "--" (no quotes) before the MID to make them look like
numbers.


"carl" wrote in message
...
I have data that looks like this:

ColA ColB
tag12!=2005 tag33!=1

is there a formula that I can place in ColB and C that will take just the
data to the right of the "=" character ?

Thank you in advance.