Find & Replace

  • Thread starter Thread starter JAD
  • Start date Start date
J

JAD

I have a list of items shown as VAV-1-1, VAV-1-2, VAV-1-3,
etc. I would like to replace each item above with VAV-1-
1P, VAV-1-2P, VAV-1-3P, etc. How can I use the Find and
Replace function in this application to just add the P
after each item? I am assuming there are wild card symbols
that I can use in place of the numbers similiar to VAV-*-
*. Any help would be appreciated. Thank You, JAD
 
Although you can use wildcards you can't add a P to that in one fell swoop,
you could
do that in Word using edit>replace but not in Excel. You would need either a
help formula
or VBA to do that,

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Hi
you could use the following formula in a helper column
=IF(LEFT(A1,4)="VAV-",A1&"P","")
and copy this down. Afterwards you may copy this row and insert it with
Edit - Paste Specials - Values
 
Type "P" in a cell, let's just say its cell B1. Assume your data starts
in cell A1 and goes down. Type in the following formula in C1:

CONCATENATE(A1,$B$1)

Copy down.

Copy column C, then Paste Special> Values.

Stephanie
 
Back
Top