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

<pre><code id="code-20-39700437-1">=LEFT(A2;3)/10&amp;&quot;cm x &quot;&amp;RIGHT(A2;3)/10&amp;&quot;cm&quot;</code></pre>
Regards
</div>


Hi,

pls try



=LEFT(A2;3)/10&"cm x "&RIGHT(A2;3)/10&"cm"

Regards

<div>
If your data starts in row 2 then enter this formula in row 2 of any blank column<br />
<br />
=LEFT(A2,FIND(&quot; &quot;,A2)-1)/10&amp;&quot;cm&quot;&amp;&quot; x &quot;&amp;RIGHT(A2,LEN(A2)-FIND(&quot; x &quot;,A2)-2)/10&amp;&quot;cm&quot;<br />
<br />
and copy it down.
</div>


If your data starts in row 2 then enter this formula in row 2 of any blank column

=LEFT(A2,FIND(" ",A2)-1)/10&"cm"&" x "&RIGHT(A2,LEN(A2)-FIND(" x ",A2)-2)/10&"cm"

and copy it down.

<div>
The Solution is :<br />
in next column write:<br />
=LEFT(A2,3)/10 &amp;&nbsp;&quot;cm x &quot;&nbsp;&amp; RIGHT(A2,3)/10 &amp;&nbsp;&quot;cm&quot;<br />
<br />
Use , between A2 &amp;&nbsp;3.<br />
<br />
Thanks,
</div>


The Solution is :
in next column write:
=LEFT(A2,3)/10 & "cm x " & RIGHT(A2,3)/10 & "cm"

Use , between A2 & 3.

Thanks,

<div>
Rgonzo1971, im getting error in formula. <br />
<br />
ssaqibh: That works perfectly, but ive also noticed some cells have: <br />
<br />
350 x 350 x 700<br />
<br />
Can we change the formula to deal with this also?
</div>


Rgonzo1971, im getting error in formula.

ssaqibh: That works perfectly, but ive also noticed some cells have:

350 x 350 x 700

Can we change the formula to deal with this also?

<div>
Thanks ssaqibh, thats a pretty impressive equation. Thanks for clearing up the Rgonzo1971 post too.
</div>


Thanks ssaqibh, thats a pretty impressive equation. Thanks for clearing up the Rgonzo1971 post too.

<div>
If your numbers are all fixed at 3 digits then you can use this simplified formula<br />
<br />
=LEFT(A2,3)/10&amp;&quot;cm x &quot;&amp;IF(LEN(A2)&gt;9,MID(A2,7,3)<wbr />/10&amp;&quot;cm x &quot;,&quot;&quot;)&amp;LEFT(A2,3)/10&amp;&quot;cm&quot;
</div>


If your numbers are all fixed at 3 digits then you can use this simplified formula

=LEFT(A2,3)/10&"cm x "&IF(LEN(A2)>9,MID(A2,7,3)/10&"cm x ","")&LEFT(A2,3)/10&"cm"

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I currently have the following in column A:<br />
<br />
220 x 300<br />
250 x 250<br />
330 x 300<br />
<br />
I need column B to be:<br />
<br />
22cm x 30cm<br />
25cm x 25cm<br />
33cm x 30cm<br />
<br />
Is this possible in an equation?<br />
<br />
Many Thanks,<br />
Dean.
</div>
</div>


Hi guys,

I currently have the following in column A:

220 x 300
250 x 250
330 x 300

I need column B to be:

22cm x 30cm
25cm x 25cm
33cm x 30cm

Is this possible in an equation?

Many Thanks,
Dean.

Convert mm into cm

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

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 applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.