excelhelp.JPG

excelhelp.JPG

newbie here,

this is an imported sheet from another company, but to input it on to our system it needs a slight re-jig.

Column "R" = words "PRIORITY" OR "STANDARD"

if this is the case i need the column "AM" answers replacing with what ever is in column "R" BUT in a different format i need it with just capital letter at beginning.
ie - "Standard" or "Priority"

is there a way of doing this quickly instead of copy and pasting across?

all help great fully received