Excel 2007 : custom IF statement

I'm not sure if this would be a macro script because it involves moving values and autopopulating... Here's a scenario

IF Col 6 'contains a P' move entire value of field (i.e. 1234P) to Column 77, AND populate Column 108 with the letter P

Why move it, why not just reference

=IF(ISNUMBER(SEARCH("p",F2)),F2,"")

and

=IF(ISNUMBER(SEARCH("p",F2)),"P","")

we're doing a data migration, the new system only accepts # values...

Column 6 = SSN

Some of our 'client's are foster children. they have what's called 'pseudo' SSN's... a unique #, but 9th character is a letter P.... therefore, column 6 would have to be cleared out... I have about 40,000 records... and about 8-12% have pseudo #'s.

the following macro should do what you are looking for it is assuming that there is data in column A to determin max rows.

Please Login or Register  to view this content.