Drag values down cells

  • Thread starter Thread starter mohd21uk via OfficeKB.com
  • Start date Start date
M

mohd21uk via OfficeKB.com

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.
 
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:
 
Back
Top