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
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
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.
Thanks for the excellent response!
Can I ask another question?
How do I do after each slash (/), the first letter be capitalized?
My attachment in the first letters are capitalized after each bar because I did manually.
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.
Don't Work, but Thank you!!
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
Re: Extract number.
I needed all the first letters capitalized.
Thank you!
Don’t have an account yet? Register yourself now and be a part of our community!