Replace ' with =

  • Thread starter Thread starter Shefali
  • Start date Start date
S

Shefali

Need to replace 'Sheet!7 with =Sheet!7. Find and Replace
does not work.
 
Try searching for Sheet instead of 'Sheet.

The ' is used to tell Excel to treat the contents of text, but isn't found
in the search.
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 
try
for each c in selection
c.value="="&right(c,len(c)-1)
next
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS word Find and Replace using Regex - Help required 0
Find and Replace only the first character 3
Attempting to boot from hard drive 3
problem with fractions to decimal 1
Merge Multiple workbook sheets into one workbook 0
Need help with a formula, please!!! 2
Find and Replace - Changing 1st # only 3
Find & Replace Special characters with numbers 2

Back
Top