April 30 - May 6, 2007
Get the lowdown on the CONCATENATE function vs. the ampersand (Excel 2000/2002/2003/2004)
There are two methods you can use for joining text from different cells—or combining the flexibility of a function within your text. You can use an ampersand (&) to combine a function with text, or the text from more than one cell. Alternatively, you can use the CONCATENATE function to combine different cell reference and text elements into a single text string. So, what's the difference? Which method should you use? For the most part, these two methods produce the same results; they combine text and/or a cell reference's data into one cell, formatted as text. The only real difference is the number of items you can combine. There's no limit to how many pieces you can combine with the ampersand symbol. However, the CONCATENATE function can't combine more than 30 items.
Change the color of your guides or grid lines (Adobe Illustrator 10/CS/CS2)
If you don’t like the color of your guides and grids, or they’re too similar to your image, you can change them. First, press [command]K or ([Ctrl]K in Windows). Next, choose Guides & Grid in the Preferences dialog box. Then, select a desired color in the Guides area and another in the Grids area. Finally, click OK.
Let Adobe InDesign perform calculations for you (Adobe InDesign 2/CS)
Was math your worst subject? Then, let InDesign perform calculations for you! For example, let's say you need to proportionately scale an object to a specific width or height. To do this, simply select the object with the Selection tool and then display the Transform palette. Now, enter the known dimension in the W or H text box. Finally, press [command][enter] ([Ctrl][Enter] in Windows). InDesign automatically calculates the other dimension and scales the image proportionately.
|
