Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.
Excel worksheet protection in Excel Online
Does worksheet protection work in Excel Online? We have a workbook where we have set certain ranges for all users (Everyone) to be able to edit without password. Enable protection on the worksheet and share the workbook in OneDrive. Users open the Excel file in Excel Online and states range is protected. Users edit in Desktop Excel and they can edit the cells. I tried to find relevant articles about if this is a limitation to Excel Online, but they are not clear. Should ranges / sheet protection work in Excel Online, or is this a limitation? Or are we doing something wrong? Found references: https://technet.microsoft.com/en-us/library/excel-online-service-description.aspx#Sheet protection "When you share an Excel file with other users, you can protect a worksheet to help prevent it from being changed, and you can choose the actions that you allow the users of your worksheet to perform." https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-F0DC28ED-B85D-4E1D-BE6D-5878005DB3B6 "Protected worksheets (not entire workbooks) can be viewed in a browser window in Excel Online." Thanks,
Microsoft Excel keeping all cells uppercase
I have a spreadsheet that several people use and would like to keep the text in a particular column always set to upper case. Regardless of case the user enters the data in this column it is saved in upper case. Is this possible? Thank you for your input. Greg
Excel 365 online, date formatting problem.
Dear all, I have a problem with date formatting, I think it is a bug in the program but I'm not sure. When editing in Excel proper, in the attached file there is a formula in column A which reads data from column B "(=YEAR(B1)+(WEEKNUM(B1)/100))". When 15/02/2017 is added to column B, I get 2017.07, which is exactly what I want. Column B is formatted for UK date system e.g. 15/02/2017. The Problem When I'm editing the sheet in my browser (and I want to do this for multiple user sharing reasons), I get #VALUE! in column A. When I look at the formatting of column B it has changed itself to Armenian or Azerbaijani, no longer UK format. If I change it again to UK, click out of the cell, then right click back into it, select number format, it has changed itself again to Armenian again. If I write the same date as an American format e.g. 02/15/2017 it works ok, but try telling everyone they have to use a special date system for this one sheet. Any ideas on how to lock the formatting when editing the sheet in a browser window?My excel sheet keeps recreating rows after I delete them
I am working on a task that requires a separate workbooks. In my second workbook there is an extra 100+ rows that I keep deleting and they are reappearing. I have tried to choose CTRL+End and the pressed clear formatting all for the rows, but then they come back again. How can I stop this from happening?Using a sheet as a dynamic master template for other sheets
We are running multiple experiments and saving the data for each in a seperate sheet. However these experiments are works in progress and we are continually updating the types of data we capture and the general format of the sheet. It would be ideal to have a master sheet that serves as a template and will update the other sheets without otherwise disturbing their seperate data. This seems like a reasonably general scenario, so I am hopeful it has a sane solution; but other approaches to achieve the same capability are welcome. Thanks in advance, John
Tabs in Excel Online worksheet move unexpectedly
We use a shared Excel Online worksheet that is concurrently accessed by approx. 50 users. The tabs are all named by date and we keep about 3 months of dates available at any time. Periodically, the current date's tab will move for no reason to somewhere random (could be in an earlier or later date tab position). The user's get confused when they are trying to find the current date and have to hunt through all the tabs to find it. We then have to manually drag it back to its correct place in the tab timeline. No one can recreate the problem. Is there a setting we can turn on to activate tab locking? Or has there been a problem reported in the past that a fix exists for? Thanks in advance for your help....