Extracting part of a cell into another... not always same character placement

  • Thread starter Thread starter johnnyrad
  • Start date Start date
J

johnnyrad

Here's a line from an export of a program called Microstrategy int
Excel:

(Period = January:2004)


I need to extract the January 2004 part. Of course the month and yea
could be any month year. What are my options in the cell(s) next t
this to extract the month and year only? I thought up a few option
that seemed completely complicated when there's probably an easie
solution.

Thanks in advance
 
Hi
if the month name is always preceded by '= ' then try the following
=MID(A1,FIND("=",A1)+2,255)
If the brackets are also exported try
=MID(SUBSTITUTE(A1,")",""),FIND("=",A1)+2,255)

Frank
 
Johnny,

This formula will do it

=MID(A1, FIND("= ",A1)+2,LEN(A1)-1-FIND("= ",A1)-1)

but it's still text

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top