<div>
Use this formula:<br />
<br />
=LEFT(A1,LEN(A1)-LEN(TRIM(<wbr />RIGHT(SUBS<wbr />TITUTE(A1,<wbr />&quot; &quot;,REPT(&quot; &quot;,99)),99)))-1)<br />
<br />
Kevin
</div>


<div>
That always enter the word 'first' into the field.
</div>


<div>
@Kevin: I think he already has column two...<br />
<br />
elliottbenzle,<br />
<br />
Please try one of these:<br />

<div class="indent">
<br />
= TRIM(SUBSTITUTE(A1,B1,&quot;&quot;))<wbr /><br />
= TRIM(MID(A1,LEN(B1)+1,1000<wbr />))<br />
= MID(A1,LEN(A1)-LEN(TRIM(RI<wbr />GHT(SUBSTI<wbr />TUTE(A1,&quot; &quot;,REPT(&quot; &quot;,99)),99)))+1,99)<br />

</div>
1: replaces the first name with &quot;&quot;&nbsp;(and trim result)<br />
2: skip from A the length of B (and trim result)<br />
3: extract last word from A (based on Kevin's expression)<br />
<br />
(°v°)
</div>


<div>
&gt; <i>That always enter the word 'first' into the field.</i><br />
<br />
When posting an expression, we always assume that the data is in cell A1, unless stated otherwise. Put “Christina Swartz” in cell A1 and “Christina” in cell B1, then try the functions in cells C1, D1, etc.<br />
<br />
(°v°)
</div>


<div>
<div class="content wysiwyg-content">
In Excel I have two columns with strings, one has a full name and one has a first name. Like this:<br />
<br />
column 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;column 2<br />
Christina Swartz &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Christina<br />
Ms. Jill A. Swedlow &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ms. Jill A. <br />
Mr. Ralph (Ed) Sweet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mr. Ralph (Ed)<br />
<br />
<br />
I want to use some kind of an equation in a third column that will fill that column with only the last name. I don't know excel very well, but I think it would look something like this:<br />
<br />
Column C = Column 1 - Column 2<br />
<br />
Does anyone know how to do this? or if it's even possible?<br />
<br />
Thanks
</div>
</div>


In Excel I have two columns with strings, one has a full name and one has a first name. Like this:

column 1                              column 2
Christina Swartz                 Christina
Ms. Jill A. Swedlow             Ms. Jill A. 
Mr. Ralph (Ed) Sweet           Mr. Ralph (Ed)


I want to use some kind of an equation in a third column that will fill that column with only the last name. I don't know excel very well, but I think it would look something like this:

Column C = Column 1 - Column 2

Does anyone know how to do this? or if it's even possible?

Thanks

Excel - subtract string to create a new column

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

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

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.