<div>
Hi,<br />
<br />
Please try below....<br />
<br />
[
<pre><code id="code-20-39970250-1">=IF(LEN(a1)=2,&quot;P000&quot; &amp; RIGHT(a1,LEN(a1)-1),IF(LEN(a1)=3,&quot;P00&quot; &amp; RIGHT(a1,LEN(a1)-1),IF(LEN(a1)=4,&quot;P0&quot; &amp; RIGHT(a1,LEN(a1)-1),a1)))</code></pre>
</div>


Hi,

Please try below....

[

=IF(LEN(a1)=2,"P000" & RIGHT(a1,LEN(a1)-1),IF(LEN(a1)=3,"P00" & RIGHT(a1,LEN(a1)-1),IF(LEN(a1)=4,"P0" & RIGHT(a1,LEN(a1)-1),a1)))

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Simple enough string manipulation here.<br />
<br />
I am looking for a neat way to convert text fields to the format P9999. &nbsp;4 digit prefixed by &quot;P&quot;.<br />
<br />
See before and after examples below.<br />
<br />
P12 to P0012<br />
P1 to P0001<br />
P123 to P0123<br />
P1234 to P1234
</div>
</div>


Hi,

Simple enough string manipulation here.

I am looking for a neat way to convert text fields to the format P9999.  4 digit prefixed by "P".

See before and after examples below.

P12 to P0012
P1 to P0001
P123 to P0123
P1234 to P1234

Convert &quot;P12&quot; to &quot;P0012&quot;

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

Convert &quot;P12&quot; to &quot;P0012&quot;

Convert "P12" to "P0012"