Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Replace.
If I am given a very large formula as assistance
with A1 as usually offerred as example. How may I do a bulk "Replace" when fitting the formula to cell say BU68 ? eg transposing all the A1's to BU68's Thankyou |
#2
|
|||
|
|||
How about
Edit/Replace, replace BU68 with A1 In article , "Rodney" wrote: If I am given a very large formula as assistance with A1 as usually offerred as example. How may I do a bulk "Replace" when fitting the formula to cell say BU68 ? eg transposing all the A1's to BU68's |
#3
|
|||
|
|||
Oh! (groan)
I was selecting the entire statement, hence replace was greyed out. (Old Database habits die hard) Thanks for your help. | How about | | Edit/Replace, replace BU68 with A1 | | In article , | "Rodney" wrote: | | If I am given a very large formula as assistance | with A1 as usually offerred as example. | How may I do a bulk "Replace" when fitting the formula | to cell say BU68 ? | eg transposing all the A1's to BU68's |
#4
|
|||
|
|||
... a very large formula ..
... a.k.a "Minestrone" ? <bg I've cobbled a decomposition in your other thread .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace absolute references | Excel Worksheet Functions | |||
REPLACE outside of highlighted column | Excel Worksheet Functions | |||
Replace Number with Text using Macro | Excel Discussion (Misc queries) | |||
Replace using wildcards | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |