![]() |
find & replace
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. |
find & replace
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. |
find & replace
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. |
All times are GMT +1. The time now is 01:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com