Parsing Data with Formulas (vs Text-to-Columns)

C

carl

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.
 
D

Dave R.

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.
 
Top