Forum

Hello Estella, I changed your formula in cell Sheet1!B2 a bit, locked either the column or row reference and then copied it over the remaining cell...

Hi, It would be much easier for us to give help if you can provide a sample file. Br, Anders

Hi Marty, True, TEXTJOIN came with Excel 2016 version. I hope you get it to work as you want it to be. Br, Anders

Hi Jim, I don't really have a solution to offer for you, as I am not to much of a big fan of using VBA, even though it is handy from time to time. ...

Hi, The problem seem to be with Windows 10 and display language set to Swedish (and possibly other languages as well). As the pictures shows it wor...

Hi Catalin, Yes, it is a Swedish version. I am using the English language pack though. I will do some test later on with switching Windows language...

Hi Helene, Apart from that you will get a #N/A result when the condition is false, as you have not completed the IF formula to handle such scenario...

Hi Marty, When you combine text and numbers in one cell like you do here Excel treats it as text, even the numbers. Below is an example of how you ...

Hi Teri, Do check this support page at Microsoft and see if it solves your problem. Br, Anders

Hi Steve, Glad that you found the answer. When searching for a list of language id:s to use with the TEXT function I found this article (one of man...

Hello, I found your issue very interesting so I have played around a bit. See the attached sheet to see my attempt to explain why you get 100 as th...

Hi Paul, A simple solution is to use ROW formula to get the row number. Your formula in cell W3 is currently: =HLOOKUP($W$2,$B$2:$T$251,2,FAL...

Hi Celeste, You go to File - Options and in there you choose "Customize Ribbon" on the left. You can organize the ribbon by just re-arranging the o...

Hi Steve, I would download respective language packs and check myself. Br, Anders