Is there any function in excel to do the opposite making TEXT function ? For example, TEXT function converts a value to text in a specific number format but I want converts text to value, how I can to do that ?
Initially I was thinking to do this using the "IF" but I'm 12 words and Excel 2003 supports up to 8 "IF's" in one formula.
Some help, please.
Hi,
Can you give some examples of the text strings you wish to convert, and to what you wish to convert them?
Regards
It is the month of the year that are written in Romanian, for example:
Ianuarie
Februarie
Martie
Aprilie
Mai
Iunie
Iulie
Septembrie
Octombrie
Noiembrie
Decembrie
I would like to convert them to numbers 1 ... 12.
Last edited by public; 11-05-2013 at 06:17 AM.
A1 = input
B1 = MATCH(A1, {"Ianuarie", "Februarie", "Martie", "Aprilie", "Mai", "Iunie", "Iulie", "Septembrie", "Octombrie", "Noiembrie", "Decembrie"}, 0)
This will look along an array of text strings and then return the index of the match.
Note this only has eleven months; it's missing August?
Last edited by ben_hensel; 11-05-2013 at 06:24 AM.
Hi,
If your list of months is orthographically identical (i.e. includes all necessary diacritics, etc.) to those in your version of Excel, you should be able to use e.g.:
=--TEXT(1&A1&2013,"m")
Regards
Sorry, but not working.
So, I have a cell which reads the value of a list (a list of months of the year). This cell (eg A3) should return the number corresponding to the month selected from the list.
Other ideas please!
Hi,
Post a sample workbook, please.
Regards
I attach a working draft file.
In cell A3 from the "macheta" sheet I want to write a excel formula to return a number that corresponds to the selected month from the sheet "raportare".
http://www.mediafire.com/download/fe...ample_work.xls
I can not attach the file above into this forum because I am private network that keeps asking me username and password when I try attach file. It's the only forum where that happens. Why? I don't know.
So the formula I gave earlier works perfectly fine, assuming you adapt the cell references accordingly (did you do this?). And, of course, as I stated earlier, providing your list of month names are identical to those that your version of Excel uses.
=--TEXT(1&raportare!B2&2013,"m")
You might need to change the "m" to whichever letter is used to represent "month" in your version.
Regards
I have Excel 2003 version in English then what should replace the "m"?
Nothing.....................
You used somehow Excel 2003 because does not work in my case when I using this formula:
=--TEXT(1&raportare!B2&2013,"m")
I used the file I attached above. I tried to change the "m" in the "month" but does not work at all.
Ah, I see. You're using an English language version of Excel but you want to keep the list of months in Romanian, correct?
If that's the case then you'll need to use a solution similar to that offered by ben_hensel.
Regards
I retrying the example shown by user ben_hensel and it works perfectly.
Thanks all.
The thread can be closed now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks