Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace - Replace with Blank Space Studebaker Excel Discussion (Misc queries) 4 April 3rd 23 10:55 AM
Find/Replace Event or Find/Replace for Protected Sheet ... Joe HM Excel Programming 2 October 27th 07 03:55 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM
Using Find and Replace to replace " in a macro snail30152 Excel Programming 1 April 13th 06 11:58 PM
Replace method - cannot find any data to replace Mike Excel Programming 5 April 6th 06 08:56 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"