<div>
Text to column with &quot;,&quot; as delimited will also work if your D &amp;&nbsp;E columns are blanks.
</div>


Text to column with "," as delimited will also work if your D & E columns are blanks.

<div>
Hi,<br />
<br />
pls try in D3<br />

<pre><code id="code-20-42130764-1">=TRIM(MID(SUBSTITUTE($C3,&quot;,&quot;,REPT(&quot; &quot;,999)),COLUMNS($A:B)*999-998,999))</code></pre>
then copy right and copy down<br />
<br />
Regards
</div>


Hi,

pls try in D3


=TRIM(MID(SUBSTITUTE($C3,",",REPT(" ",999)),COLUMNS($A:B)*999-998,999))

then copy right and copy down

Regards

<div>
This worked perfectly ProfessorJimJam! Thank you!
</div>


This worked perfectly ProfessorJimJam! Thank you!

<div>
Sorry guys I did not see the new comments till after I accepted the other solution. Notifications did not come through for some reason.
</div>


Sorry guys I did not see the new comments till after I accepted the other solution. Notifications did not come through for some reason.

<div>
<div class="content wysiwyg-content">
All, is there a formula that can extract city and state from a cell in Excel<br />
<br />
format is like so: &nbsp; 100 any street, South Plainfield, NJ<br />
<br />
The cells start at C3 on down.
</div>
</div>


All, is there a formula that can extract city and state from a cell in Excel

format is like so:   100 any street, South Plainfield, NJ

The cells start at C3 on down.

I need to extract city and state from a cell in 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.

Microsoft Office

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