How to use wildcard search/replace

J

Jack

I have a column of items named something like
16PHYZE600
BSBLZAM100
08PHZIM455
FRBBZIT560

I need to change them all so that they start with HPR- and end with
..jpg. So the above files would look like the following.

HPR-16PHYZE600.jpg
HPR-BSBLZAM100.jpg
HPR-08PHZIM455.jpg
HPR-FRBBZIT560.jpg

I've tried using just * in the Find string and HPR-*.jpg in the
replace string but it just replaces everything with HPR-*.jpg

Does anyone know how I would go about doing the above?

Jack
 
F

Frank Kabel

Hi
one way: use a helper column with the following formula
="HPR-" & A1 & ".jpg"

copy this for all rows and the use 'Edit - Paste Special - Values' to
remove the formulas
 
Top