| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
A1 B1-B200
concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying information from one cell to another without modifying it. | New Users to Excel | |||
| What formula do I use for copying cell information between workboo | Excel Worksheet Functions | |||
| Copying Cell information | Excel Worksheet Functions | |||
| vlookup is returning a value one cell above the correct cell. | Excel Worksheet Functions | |||
| Comparing and copying information from one cell to another | Excel Worksheet Functions | |||
Threaded Mode
