I'd like to extract the numbers in column A.
The result is that I want to manually put in column C.
If someone help me podeer.
thank you
Extract number.
-
-
Re: Extract number.
See formulas in column E
-
Re: Extract number.
If the number you want is always preceded by "Cod." then followed by a space then the first / in the cell, type =RIGHT(LEFT(A2,FIND("/",A2)-2),FIND("/",A2)-7) in C2, then copy it down.
-
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.
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 number.
See formulas in column G this time
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!