Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
Is it possible only with "find & replace", put a string before the same contents ? I mean: - I have 50 cells contains only 2 letter ("AA", "BB", "CA", ...) - I need to insert string "demo: " The result - with F&R - in the 50 cells must be ("demo: AA", "demo: BB", "demo: CA", ...) No vba and no formulas (es. "contatenate", ...). thanks to all M. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
just wondering - why are you posting in the programming newsgroup if
you don't want a vba answer? without vba & without a formula, the only thing i can see is doing it one at a time using F&R. maybe somebody else has a different answer. susan On May 19, 9:51*am, "mino" wrote: Hi. Is it possible only with "find & replace", put a string before the same contents ? I mean: - I have 50 cells contains only 2 letter ("AA", "BB", "CA", ...) - I need to insert string "demo: " The result - with F&R - in the 50 cells must be ("demo: AA", "demo: BB", "demo: CA", ...) No vba and no formulas (es. "contatenate", ...). thanks to all M. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
select the areareplace aa with demo: aa, etc
-- Don Guillett Microsoft MVP Excel SalesAid Software "mino" wrote in message ... Hi. Is it possible only with "find & replace", put a string before the same contents ? I mean: - I have 50 cells contains only 2 letter ("AA", "BB", "CA", ...) - I need to insert string "demo: " The result - with F&R - in the 50 cells must be ("demo: AA", "demo: BB", "demo: CA", ...) No vba and no formulas (es. "contatenate", ...). thanks to all M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
Replace method - cannot find any data to replace | Excel Programming |