Help formatting a list of fields

[sscornav]

I have a list of values that are formatted like P1234 and have a hyperlink.

I need to have a way to format a large list to remove the hyperlink from each field and add a period after the "P" like P.1234.

It could be a macro or manual, but the list is large.

Any suggestions?

Excel Workbook
	A	B
1	Old Number	New Number
2	P3178	P.3178
3	P3178	P.3178
4	P3178	P.3178
5	P3178	P.3178
6	P3179	P.3179
7	P3180	P.3180
8	P3181	P.3181
9	P3182	P.3182
10	P3183	P.3183
Sheet1

 

[sscornav]

Is there a way to remove the hyperlink from more than 1 field at a time?

Is there any way to do a global replace? like PXXXX = P.XXXX?

 

[jim may]

In xl 2007 Select the entire range; Home(Tab) Click dropdown on Find & Select; Choose Replace... On Replace Tab in Find What Box enter P
in Replace with: enter P.
Clcik Replace All

 

[sscornav]

I'm sorry, I should have noted that I am using 2003.

 

[jim may]

I no longer have access to or remember exactly, but look under the Edit menu (in xl 2003) for the same opportunities/selections...