Excel 2013

  1. text!Returns the number (code point) corresponding to the first character of the text!is the character that you want the ...
  2. text!Returns the number of characters in a text string!is the text whose length you want to find. Spaces count as characters! ...
  3. text!Returns the number of characters in a text string. Use with double-byte character sets (DBCS)!is the text whose length ...
  4. text,decimal_separator,group_separator!Converts text to number in a locale-independent manner!is the string representing ...
  5. text,number_times!Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string!is ...
  6. text,num_bytes!Returns the specified number of characters from the end of a text string. Use with double-byte character sets ...
  7. text,num_bytes!Returns the specified number of characters from the start of a text string. Use with double-byte character ...
  8. text,num_chars!Returns the specified number of characters from the end of a text string!is the text string that contains ...
  9. text,num_chars!Returns the specified number of characters from the start of a text string!is the text string containing the ...
  10. text,old_text,new_text,instance_num!Replaces existing text with new text in a text string!is the text or the reference to ...
  11. text,start_num,num_bytes!Returns characters from the middle of a text string, given a starting position and length. Use with ...
  12. text,start_num,num_chars!Returns the characters from the middle of a text string, given a starting position and length!is ...
  13. text1,text2!Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive!is the ...
  14. text1,text2,.!Joins several text strings into one text string!are 1 to 255 text strings to be joined into a single text string ...
  15. That command cannot be performed on a protected sheet because the source data for this PivotTable report requires a data ...
  16. That command cannot be performed while a protected sheet contains another PivotTable report based on the same source data.To ...
  17. That command cannot be used with selections that contain entire rows or columns, and also other cells. Try selecting only ...
  18. That control can only be used while the worksheet is displayed in a separate window. Do you want to open a window for the ...
  19. That workbook cannot be merged because it contains changes that have not been merged followed by later changes that have ...
  20. The "Evaluate calculated members from OLAP server in filters" setting will also be changed for all other PivotTables connected ...
  21. The "Include new items in manual filter" setting will also be changed for this field in all other PivotTables connected to ...
  22. The "Show calculated members from OLAP server" setting will also be changed for all other PivotTables connected to the same ...
  23. The 'Applies To' range and the 'Data Source' range for the selected rule do not match. Select the entire Data Source range ...
  24. The action cannot be completed in Compatibility Mode. To complete the action, you can select less data or save the workbook ...
  25. The authentication method used by {0:ExcelCalculationServer} to retrieve workbook files from all non-{0:Wss} trusted file ...
  26. The calculated field could not be deleted because insufficient memory is available. Simplify the PivotTable report, or close ...
  27. The calculation mode of workbooks in {0:ExcelCalculationServer}. All of the settings except the File setting override the ...
  28. The cell or chart you're trying to change is on a protected sheet.To make changes, click Unprotect Sheet in the Review tab ...
  29. The change history for this workbook is corrupt. Unless the workbook is removed from shared use, Excel may not be able to ...
  30. The changes you made to this query, such as choosing a different data object or changing columns, have altered the original ...
  31. The Chart Data Range is too complex to be displayed. If a new Data Range is selected, it will replace all of the series on ...
  32. The chart name that you specified contains characters that cannot be used. Use any character in a chart name except a colon ...
  33. The chart name you specified cannot be used. You can use any character in a chart name except a colon (:), backslash (\), ...
  34. The column width that you have selected is wider than a page. If you continue, Page Layout View will be unable to correctly ...
  35. The column you selected is not in the original selected range. Either select a column in the original selected range, or ...
  36. The column you selected is not in the original selected range. Either select a column in the original selected range, or ...
  37. The command could not be completed because you are attempting to filter on a cell in the table header. Select a cell in the ...
  38. The command could not be completed because you are attempting to filter on a total row cell. Select a cell in the table's ...
  39. The command could not be completed because you are attempting to filter on the filter header. Select a single cell in the ...
  40. The command text isn't set for the connection |0. To edit the command text, go to the Connections Manager on the Data tab ...
  41. The Compare and Merge operation cannot be completed because some parts of the document being merged from could not be read. ...
  42. The connection in this workbook will no longer be identical to the connection defined in the external file located at '|'.The ...
  43. The current operation cannot be completed.Possible reasons include: - You attempted to drill down from the lowest level of ...
  44. The current selection includes one or more calculated members that cannot be manually filtered. To apply the filter to the ...
  45. The current selection is not within a refreshable region of the workbook.Select a refreshable region, such as a PivotTable, ...
  46. The current title is based on a formula which cannot be displayed. If a new title is entered, it will replace the formula. ...
  47. The Data Connection File {1} used in the workbook is not in a trusted location. The following connections failed to refresh:{2} ...
  48. The data connection path in the workbook points to a file on the local drive or is an invalid URI.Verify that the path to ...
  49. The data connection uses None as the external data authentication method and Unattended Service Account has not been configured. ...
  50. The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed ...
  51. The data range is too complex to be displayed. If a new range is selected, it will replace all of the series in the Series ...
  52. The data received from the source database could not all be displayed in the PivotTable report. You may be able to display ...
  53. The data source of a PivotTable connected to filter controls that are also connected to other PivotTables cannot be changed.To ...
  54. The data that you are attempting to map contains formatting that is incompatible with the format specified in the worksheet. ...
  55. The data you want to import or link will replace existing data. What do you want to do?* To replace the existing data with ...
  56. The database driver does not include necessary capabilities and cannot be used with Excel. Contact your database administrator ...
  57. The database driver does not support this type of query.For information about the types of queries the driver supports, see ...
  58. The dates you specified for the axis values can't be used, because the maximum axis value must occur at a later date than ...
  59. The default row height of sheet '{0}' is 0. It will not bepossible to clean this sheet.Would you like to continue processing ...
  60. The destination range is not large enough to accommodate all copied rows. Data below the destination range will be lost. ...
  61. The document is corrupt and cannot be opened. To try and repair it, use the Open and Repair command in the Open dialog box ...
  62. The document location is not accessible. To create a (!idspnVisio_NV) PivotDiagram the document must be saved locally or ...
  63. The document must be a .xls, .xlsx, .xlsm, or .xlsb file to create a (!idspnVisio_NV) PivotDiagram. Save the document in ...
  64. The document was saved successfully, but Excel cannot re-open it because of a sharing violation. Please close the document ...
  65. The EffectiveUserName connection string property is an alternative to Windows delegation for allowing users to securely access ...
  66. The Error Tracer encountered existing arrows or a circular reference. Delete all tracer arrows or resolve the circular reference, ...
  67. The Error Tracer has encountered a branch point. Double-click the branch you want to follow and choose Trace Error again. ...
  68. The Evolutionary Engine and Multistart option require that you specify both upper and lower bounds on all the Variable Cells. ...
  69. The Evolutionary engine maintains a population of candidate solutions. This option sets the number of candidate solutions. ...
  70. The Evolutionary engine makes extensive use of random sampling to generate trial points. If you set a value greater than ...
  71. The Evolutionary engine samples trial values between the upper and lower bounds of the variable cells, and is likely to be ...
  72. The expected items could not be found on the OLAP server. In some cases, this can happen if the dimension data has been changed. ...
  73. The external data range contains one or more columns that were added in Excel. When you publish this data to the Web with ...
  74. The field you are dropping into the column area exceeds | items. Only the first | items will be displayed as columns. To ...
  75. The field you are hiding has label, date, or value filters applied. Do you want to delete the filters and hide the field? ...