<div>
Hi,<br />
<br />
If the full names are in column A, then paste in this formula to another column and copy down:<br />
<br />
=MID(A1,FIND(CHAR(1),SUBST<wbr />ITUTE(A1,&quot;<wbr /> &quot;,CHAR(1),LEN(A1)-LEN(SUBS<wbr />TITUTE(A1,<wbr />&quot; &quot;,&quot;&quot;))))+1,LEN(A1))<br />
<br />
I think I got that from someone else, so I should be crediting someone - I apologise for not recalling who!<br />
<br />
Alan.<br />
<br />
Edit: &nbsp;Found the source: Jean-François Corbett posting in StackOverflow<br />
<br />
<br />
&lt;&lt;Link to competing Q&amp;A web site omitted. Name of poster on that site added.--byundt, Microsoft Excel Topic Advisor&gt;&gt;
</div>


Hi,

If the full names are in column A, then paste in this formula to another column and copy down:

=MID(A1,FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,LEN(A1))

I think I got that from someone else, so I should be crediting someone - I apologise for not recalling who!

Alan.

Edit:  Found the source: Jean-François Corbett posting in StackOverflow


<<Link to competing Q&A web site omitted. Name of poster on that site added.--byundt, Microsoft Excel Topic Advisor>>

<div>
<div class="content wysiwyg-content">
In column A I names. Some are first and last, some are first, middle and last. In Column B I want just the last name. Somehow tell Column be to take out everything up to the space bar on the left of the last name. Any way to make this happen?
</div>
</div>


In column A I names. Some are first and last, some are first, middle and last. In Column B I want just the last name. Somehow tell Column be to take out everything up to the space bar on the left of the last name. Any way to make this happen?

Pull last name out of cell

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