We help IT Professionals succeed at work.

Convert mm into cm

405 Views
Last Modified: 2013-12-06
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.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
Hi,

pls try

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

Open in new window

Regards
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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.

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

Use , between A2 & 3.

Thanks,

Author

Commented:
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?
Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks ssaqibh, thats a pretty impressive equation. Thanks for clearing up the Rgonzo1971 post too.
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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"
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.