![]() After calc you can copy the range & paste special (values) back into range a2.X2 &am. ![]() In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. ) Click the Tools menu, and then click Excel Add-ins. For Mac: (Note: The Analysis ToolPak is not available for Excel for Mac 2011. Try going to an empty part of the sheet (say row a4) & type =a2&' ' or 'any character' then copy that across the row for your range. If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it. I want to make all the cells in row 2 to have a space so cell A2 contains 'ABC ', cell B2 contains 'DEF '. ![]() The reason i need to know is becuase i'm working with office sharepoint server 2007 and i cannot access a file thru the web access web part because it says: 'The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services: External data ranges (also called query tables)' anyone? I want to add a space (or any character(s)) after each text value in all the cells in a row or in a column For example, cell A2 contains 'ABC', cell B2 contains 'DEF', and so on. I have run the vb macro code on to check if i have any external data sources or data ranges but there are none.
0 Comments
Leave a Reply. |