User Profile
lissajo64
Copper Contributor
Joined Sep 11, 2019
User Widgets
Recent Discussions
Problems with Office 2016 Notebook opening in Office 365
I have just started using Office 365 and am trying to open some existing Office 2016 notebooks. I get to choose notebooks to open, click on the one I want (on this computer) and choose Open. I pick my cloud account then Upload. It shows Opening for a bit, then I get an error: Microsoft OneNote Something went wrong and we can't do what you asked. We're sorry Error Code: 0x80004005. I also tried creating a new notebook and I get the error: Microsoft OneNote We were unable to create your notebook. Check your internet connection and try again. My internet connection is fine. Any suggestions? Thanks in advance!862Views0likes0CommentsRe: TEXTJOIN function not ignoring blank cells
SergeiBaklan I went in and added TRIM and was getting #VALUE! as the result. I then went into the fields and checked for spaces, replacing with nothing. It did find spaces in those columns so those were fixed. I was still getting the #VALUE! error using =TEXTJOIN(" ", TRUE, TRIM(A3:G3)). I guess it didn't like having the TRIM function in there when there was nothing to trim because when I removed that it worked as it should. Odd to me that the TRIM function would cause an error, I would have thought it would just ignore if it weren't needed. Thanks so much for your help!19KViews0likes1CommentTEXTJOIN function not ignoring blank cells
I am trying to concatenate individual parts of an address into a full address field using the TEXTJOIN function. For example I have Address Number, PreDirection, PreType, StreetName, StreetType, etc and would like them in one field separated by spaces. Some of those fields may be blank so I want those ignored. My understanding is that TEXTJOIN is supposed to make that easy. I would expect that using =TEXTJOIN(" ", TRUE, A2:G2) would accomplish that however I am still getting extra spaces where the empty cells were as seen in the example: 7025 TAYLOR CREEK RD Any idea why this is happening? Thanks in advance !20KViews0likes3Comments
Recent Blog Articles
No content to show