Formula help to return first name space last name from 2 cells

[zone709]

Hi I am trying to pull from the sheet below into my cell the first and last name from Job Costing. In the sheet below first name is in C2 and last name is in B2. Then eventually I would scroll down. I looked up =Right Len, but confused its saying maybe I need to do =Left len any help thanks



='Job Costing'!

 

[Rick Rothstein]

Hi I am trying to pull from the sheet below into my cell the first and last name from Job Costing. In the sheet below first name is in C2 and last name is in B2. Then eventually I would scroll down. I looked up =Right Len, but confused its saying maybe I need to do =Left len any help thanks



='Job Costing'!

Give this a try...

='Job Costing'!C2&" "&'Job Costing'!B2

 

[zone709]

Terriffic works great thanks for the help