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: 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