On Wed, 4 Oct 2006 09:04:02 -0700, T Miller
wrote:

I need to remove a value in a cell and place only that value in the next
cell, example:

Column One Column Two
CS/4 BX/40 EA 40
CS/72 EA 72
EA 1

Is there an IF statement that can do this? I have 1200 rows of these and I
need to just have the last number in column two and where there is text(EA) I
need it to show the number 1? Can this be done?

To extract the last number from a cell, or show a 1 if there no number in the
cell, download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr

This add-in can also be easily distributed with your workbook, if that is a
requirement.


Then use this Regular Expression formula:

=--IF(REGEX.MID(A1,"\d+",-1)="",1,REGEX.MID(A1,"\d+",-1))


--ron