Conernesto

Excel & VBA Expert

Subodh Tiwari (Neeraj)

<div>
<div class="content wysiwyg-content fr-view">
I need an Excel formula. &nbsp;In Cell Q I have values as shown below. If there is a space on the text, I need the first values before the space. If there is now space I need the third and fourth digits from left to write.<br>&nbsp; &nbsp;<br>Have&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Want<br>&nbsp;<table><tbody><tr><td>USIL000016&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IL</td></tr></tbody></table>&nbsp;<table><tbody><tr><td>AL BIRMI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AL</td></tr></tbody></table><br>
</div>
</div>



I need an Excel formula.  In Cell Q I have values as shown below. If there is a space on the text, I need the first values before the space. If there is now space I need the third and fourth digits from left to write.
   
Have                Want
 
USIL000016            IL
 
AL BIRMI                AL

Excel Left formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.