Re: Add/Replicate Text In Cell Entry
Tech-Archive recommends: Speed Up your PC by fixing your registry
As mentioned (the source data assumed in B1 down), put the formula in an
adjacent cell, say C1, then copy down. Then copy col C and do a paste
special > values to overwrite col B. Then delete/clear col C.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" <royokinawa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B3305874-D9C6-40AE-A748-E30DE29424F4@xxxxxxxxxxxxxxxx
> I might be doing something wrong.
> I keep getting a circular reference when try the formula.
>
> Here is an example of what I have. I want to put WONO in front of the
rest w/o having to type it in one at at time:
>
> B
> WONO5314RY89
> 5323RY90
> 5214RY64
> 5300RY67
.
Relevant Pages
- Changable Cell reference
... you may provide some more information how your source data ... >another cell which could be changed by a dropdown to the ... >Although the spreadsheet works fine now it is a little ... >difficult when management want to focus on different ...
(microsoft.public.excel.worksheet.functions) - RE: If false then do nothing
... Here's what I'd like to do for the source data in block B4:F7, ... IF statement is used to grab all the B-column information for March 23, ... For example I want to preserve the information in cell B4, ... information, which is what I don't want, or it's going to return a "" or zero ...
(microsoft.public.excel.misc) - Re: Arrays, Dates & Blank Cells
... An empty cell will evaluate to month number 1. ... I've got a workbook with 2 sheets: Summary and Source Data. ... The Source Data sheet has a number of named ranges. ... The Summary sheet uses formulas to summarize the data contained in the ...
(microsoft.public.excel) - RE: append 2 cells, delete old
... You currently have 2 columns one with source data and one with final data. ... You can also delete the Test column at this point if you like... ... > I constructed a formula to append data from one cell to the cell above, ...
(microsoft.public.excel.programming) - Re: Columns to Rows
... If source data is in Sheet1, ... and data is 32 Rows x 35 Cols ... Use in any starting cell, ... Use in any starting cell in Sheet2: ...
(microsoft.public.excel.worksheet.functions) |
|
