Hi Mohd,

one way to do it is: imagine that your data are in column A, you could
create a formula like this
=if(left(a4,3)="PRJ";A4;B3)
Copy it down, and copy the column be column A pasting special

hope this helps
Regards from Brazil
Marcelo



"mohd21uk via OfficeKB.com" escreveu:

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