editing or added text to a filtered list

Posted by Allen on March 22, 2001 8:26 AM

This there an easy way to edit a filtered list, I have phone numbers that need to have area codes added. I have tried the trick of combine the cells of two columns, the number and area code but it doesnt work on a filtered list.

Thank You

Posted by Dave Hawley on March 22, 2001 10:49 PM

Hi Allan

Lets assume your table of data is Range A1:C100 and you have this filterted to show only every 10th row (or whatever).

Select D2:D100, then push F5, Click Special-Visible cells.

Type: =A2&B2 (if row 2 is visible) in the formula bar and push Ctrl+Enter.

This will combine the contents of all visible cells only.

Dave

OzGrid Business Applications

Posted by Allen on March 23, 2001 3:56 AM

Thank you