I have a column in a spreadsheet with values listed below

PRJ WBS-025554
WBS-031150
WBS-121351
WBS-155455
PRJ WBS-025555
WBS-0151415
WBS-0215454

I would like to drag all the values that start with PRJ until the next PRJ is
reached. I have illustrated this below:
PRJ WBS-025554
PRJ WBS-025554
PRJ WBS-025554
PRJ WBS-025554
PRJ WBS-025555
PRJ WBS-025555

Many Thanks in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200606/1