View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tegger tegger is offline
external usenet poster
 
Posts: 16
Default first name and a second name - In Sheet2 I only need the first name

Sheet1 Range A2 contains a first name and a second name.

Sheet2 Range A2 contains =(Sheet1!A2)

In Sheet2 I only need the first name.

Can I do this with a formula?



Thanks,

DL