ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   find & replace (https://www.excelbanter.com/excel-programming/411167-find-replace.html)

mino[_2_]

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.



Don Guillett

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.



Susan

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