- Points
- 8
- Trophies
- 1
- Posts
- 2
For those of you that know what an indented BOM is this will make perfect sense.
Below is what I have tried and failed at, so it may not be possible to do what I want but I'm sure someone can come up with Plan B.
Pocket watch serial number search.
e.g. C2 will have the formula: =IF(A2=2,F2,')...D2 will have the formula: =IF(A2=3,F3,')
etc.
So the issue is that the formulas keep the adjoining cells from displaying all of the F column info and will display only what fits into the cell.1. Is there a way for all of the information to display across cells with formulas..OR
2. Using Example 2, below, is there a way to indent the information in the same column (B) by reading column A?- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
- Points
- 8
- Trophies
- 1
- Posts
- 2
For those of you that know what an indented BOM is this will make perfect sense.
Below is what I have tried and failed at, so it may not be possible to do what I want but I'm sure someone can come up with Plan B.
Pocket watch serial number search.
e.g. C2 will have the formula: =IF(A2=2,F2,')...D2 will have the formula: =IF(A2=3,F3,')
etc.
So the issue is that the formulas keep the adjoining cells from displaying all of the F column info and will display only what fits into the cell.1. Is there a way for all of the information to display across cells with formulas..OR
2. Using Example 2, below, is there a way to indent the information in the same column (B) by reading column A?- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
Using the Increase Indent Button Enter your text into the document. Select the cell (s) whose entries you want to indent. (Make sure the cursor is not blinking within the selection.). If you don't have a number pad or forget a key combination, here's another quick easy way to insert bullet in Excel: Select a cell where you want to add a bullet point. On the Insert tab, in the Symbols group, click Symbol. Optionally, select the font of your choosing in the Font box.
How To Indent Within An Excel Cell Function
February 17th 06, 06:03 PMposted to microsoft.public.excel.misc |
Insert a column to the right of the cells displaying indents, in the first cell of the newly inserted column enter the formula =Trim(CellAddress), where cell address is the cell directly to the left of the current cell. Copy the formula down the column as far as necessary. Copy the formula in the inserted column, move to the top of the column to its left and do a Paste/Special and select Values. When finished delete the column with the trim formula in it. -- Kevin Backmann 'DB--less than excel expert' wrote: How can I remove an indent within a cell? For example, I have a column of data that has several different indents some with no indent. How do I remove all of the indents? When I look at the formula for cells with indents, I see =' XYZ5 My data appears in the column as follows XYZ5 XYZ4 XYZ3 XYZ2 I would like all of the data to be left justified w/o having to manually go in and delete the ' from the cells. Many thanks, DB |
