Feb 06, 2015 Since this is a Word IT forum for Windows, in the future you should use the answers.microsoft.com forum. It specializes in Word for the Mac. BTW - Paul stops by there also, so you'll still get his advice from there.
I have been using Excel (XP) to make a text chart for several months. Some of my text entries are rather lengthy. The past two weeks these lengthy entries are showing up as pound signs (#########) when I click off the cell. I know the text will fit in the cell, and the problem isn't solved by making the cell bigger or using a little bit less text. I have the cells formatted as 'text' and 'wrap to fit'. I have printed the pages and the printed version also has pound signs. I just want my text to show up!
![Mac Mac](/uploads/1/2/5/3/125373950/491103972.jpg)
I have a textbox in my userform where anything typed in the box is entered into cell A2 in my worksheet. However, multiple lines of text are not properly displayed in my worksheet. I have enabled MultiLine and EnterKeyBehaviour in the properties window of the textbox so I can type multiple lines in my textbox. The problem is that when I press the button to enter the text from my txtbox to cell A2, the cell doesn't actually display the text in separate lines. It just places a square symbol in the place that enter should have been pressed and the text should have been split into separate lines.
How can I get the separate lines of text in my textbox to be properly displayed in a cell? Thanks for your help in advance. I am new to Excel and I am creating fillable forms in excel which are protected so that users canonly input data in certain cells.
I am using Excel 2003. The users told me that they do not want text to go beyond the edge of the page when they are inputting data. They also want the words to wrap when they reach the end of the sentence.
I am also using check boxes(yes/no) and Ifind it difficult to make the adjacent cells fillable only Thanks for your help and correct me if I am wrong as I am new to this board. I saw two threads in this forum that asked this question, with no good answer. I am posting this solution for anybody still struggling with this.
The question: How can you prevent a cell's contents from overflowing into the next cell? Of course, you can make the column wider or turn on text wrapping, but you might not want to. Each of those solutions can mess up the layout of your sheet. You may just want to truncate the value. Some people have suggested putting a space in the next cell.
This is unnecessary, a pain in the but, and will mess up any ISBLANK type formulas, among other things. The solution: Select the cells in question and turn on text wrapping (FormatCellsAlignmentWrap Text). Now select the row(s) in question and manually set the row height, by right clicking the row number and selecting 'Row Height'. Check the height of an adjacent row for a good value. Your cells will now not spill over either horizontally or vertically.
They will simply truncate anything that doesn't fit. Be careful now, because parts of your data may be hidden. This can cause its own set of problems if one or two digits are neatly hidden away. Think ahead if other people might be using this sheet, and not be expecting to have some data hidden. Tested in Excel 2002.
Hello, Here is my issue: I have a list of SKUs in Excel and I need to add one same word to 500 cells that have pre-existing text in the cells. See example below: 1) List of SKU's in cells: 34 35 39 55 2) text that needs to be added IN FRONT of every number: DF So the result would be: DF34 DF35 DF39 etc. How do I do that in a formula and not manually? I found another similar thread and I understand how to do it from the instructions there but the same text goes on the back and the result is: 34DF but I need it to be like: DF34. I am using Office 2007 for mac. Thank you for the help, Chris. I have found similar posts on the forum, but nothing without use of a userform.
I have the following code: Code: Sub Development Pass = InputBox('Please enter development password', 'Password') If Pass = 'XYZ' Then UnhideAll Else: MsgBox ('Password incorrect, please try again') End If End Sub This works, but I want to hide the text as it is entered. Is there a way I can enter this as a property?
Inputbox.text.property =. Or something??
I've tried what seems intuitive, but nothing works. I would like to copy a small table from Word into one cell in an Excel worksheet. The first column of the table is a list of numbers. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem.
Excel pastes the data into several rows. When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only. What I tried that didn't work:. Formatting the Excel cells as text before pasting the data. The various options for 'Paste Special.' The closest I got was inserting the table as a Document Object, which could be a workaround, I guess. What I am saving for when all else fails:.
The obvious solution of copying row by row into one Excel cell. The data in the table is information about my dad's medications. I would like to have reference charts of how to identify the strength of each tablet by its color and markings. I got the info from the manufacturers' websites and entered it into tables in Word, which I would like to copy into a more comprehensive file I am creating in Excel.
The first column of each table is the strength of the tablet, entered as 1 mg., 2 mg., etc. The subsequent columns describe the shape, color, and markings. There are 3 tables, each with about 4-5 rows. Is there a way to copy each one - whether as a table or as text - into a single Excel cell without losing data? I have two columns in my spreadsheet. Column A has no blank fields, Column B has some blank fields.
I would like to show the text from Column A in the same row of Column B only when Column B is blank. So, basically I'm after: If column B has text, do nothing. If column B is blank, then list text from Column A. Right now I've created Column C with this formula =IF(ISBLANK(B1), A1.
That's working to get the text from A1 when B1 is blank. What can I do/add to get it pull the text from B1 if there is text there? Or.is there a better approach altogether? I was wondering if anyone could help me out please?!?! I need to have a cell on Sheet2 display the TEXT from a cell on Sheet1, is his possible?? Example: Sheet1, Cell A1 contains a clients name and I would like to have Sheet2, Sheet3, Sheet4 etc.
Display that clients name in a cell of my choosing (could be a different cell on each Sheet) automatically after entering it once on Sheet1, cell A1. I thought this was possible but I can't seem to figure it out. I haven't done any real Excel work in quite a long time but I thought I had done this before a long time ago!! Any help would be GREATLY appreciated!!
Thanks in advance. If I use autosum to do this it just displays the number 0, obviously, since it is trying to add numbers. I uploaded a copy of the spreadsheet, What I would like to happen is have the text from Sheet1,D4 automatically be placed in Sheet2,A1 and Sheet3, B2. Hope this helps -Aric. I am looking for assistance in having one cell in a text format equals another cell that contains a time value in hh:mm format.
For example: Cell A1 has a time format (hh:mm) value of 04:00; which is the Start Time. I would like cell D1 to have a text format value of '04:00' (result is dependant upon what is entered in A1). I would duplicate the same formulas to reflect Stop Times in other cells. My final result is to have another cell (F1) use the Concatenate formula to have the Start and Stop time shown in one cell as '04:00 - 12:30'. The times would change based on the Time formated values entered into the Start and Stop time cells.
I have researched this in the board and found many excellent ways to do the opposite, but not convert Time format to Text format. Any assistance is greatly appreciated. Is it possible to import a single text file into Excel, splitting the incoming data across multiple worksheets rather than a single worksheet? Each each row on the text file would be evaluated by the value in one of it's 'columns' and written to the appropriate worksheet. The file is '!' Delimited and has 11 columns for each row.
Currently, I import the file into one worksheet and cut/paste the rows manually into new worksheets/tabs. The files are very large, sometimes exceeding the 65,536 row limit, which I could avoid if the data was split out coming in. Any help anyone could provide would be WONDERFUL.