title: how to check if FirstName is empty then fill it from full name in excel file?
body: <p>I have a excel file, need to check if firstname is null or blank then extract the first name from full name column for example:</p>
  
  <p>Full Name is :: Ram Singh
  then i want to Ram in First name column.</p>
  
  <p>I have tried the following formula but it returns always 0 to me as value of firstname.</p>
  
  <pre><code>=IF(ISBLANK(F3), F3, C3)
  </code></pre>
  
  <p>FirstName is in F3 and Full Name is C3.</p>
  
  <p>Second Thing i want same thing for Full Name: if Fullname is empty then it concatenate the firstname and lastname </p>
  
  <p>please help me how can i achieve my goal. </p>