Posts by jproffer

Re: Percent Format Not working Properly for Percents < 1

Try this as a custom cell format:

.00"%"

If you are doing any calculations off of these cells, be careful with this.

Re: Extract number.

See formulas in column G this time

Re: Extract number.

It worked in your example workbook. Are their cell values that start differently than "Cod." and then a 1-3 digit number then a "/" ?

15 characters worked for all of your examples, but you may have to adjust that to a different number to account for other values.

Re: extract last name only

This should get just the last name regardless of middle initial or middle name.

=TRIM(IF(ISERROR(FIND(" ",A1,FIND(" ",A1)+1)),MID(A1,FIND(" ",A1),9999),MID(A1,FIND(" ",A1,FIND(" ",A1)+1),9999)))

Re: Extract number.

You could use:

=PROPER(LEFT(A2,15))&RIGHT(A2,LEN(A2)-15)

notice that 15 is just an approximation of what will "cover it" in your examples. This will capitalize the first word after the first "/" character.

Re: Extract number.

See formulas in column E

Re: UDF - Find last used column within row

You could try this instead:

Function LastInRow(MyRow As Long)
    LastInRow = Cells(MyRow, Columns.Count).End(xlToLeft).Column
End Function