You can use a formula. If it is always letter number, then use

=LEFT(A1,1)

and

=RIGHT(A1,LEN(A1)-1)

If it is more complex, you can us

=LEFT(A1,MAX(ISNUMBER((MID(A1,ROW($1:$100),1)*1))* ROW($1:$100))+1)

and

=MID(A1,MAX(ISNUMBER((MID(A1,ROW($1:$100),1)*1))*R OW($1:$100))+2,99)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"dok112" wrote in
message ...

Hello all, I need some assistance please....I have a macro that is
putting a reference into a particular cell...the reference depends on
the cell that certain information is placed in, so it can differ every
time the macro is run. Now, I need a way to take that cell and break
it up into the letter and number. ie. Range("A3").value = "G33"...I
have another macro that is going to use the value "G33", but I need it
to break it apart into the letter "G" and the number "33"...is this
possible?? Any help provided will be greatly appreciated!


--
dok112
------------------------------------------------------------------------
dok112's Profile:
http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=380380