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

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
>