<div>
THanks for the solution, I will keep them all for future.<br />
<br />
I used text to columns with comma. &nbsp;That was a new one for me.<br />
<br />
I gave Barry the most points since he got in first :) &nbsp; <br />
But thanks to all!<br />
<br />
Rowby
</div>


THanks for the solution, I will keep them all for future.

I used text to columns with comma.  That was a new one for me.

I gave Barry the most points since he got in first :)  
But thanks to all!

Rowby

<div>
<div class="content wysiwyg-content">
HI<br />
<br />
I have a spreadsheet with one column in the following format:<br />
<br />
DOE, JOHN &nbsp; (lastname, firstname)<br />
<br />
Can someone give me a formula for separating the first and lastname into two columns.<br />
<br />
Thanks!<br />
<br />
<br />
Rowby<br />
<br />

</div>
</div>


HI

I have a spreadsheet with one column in the following format:

DOE, JOHN   (lastname, firstname)

Can someone give me a formula for separating the first and lastname into two columns.

Thanks!


Rowby



Excel Formula for Separating First and Last Name into separate columns

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