inches millimeters in the same cell

[SirCasak]

I am trying to take 2 feet in cell A1 and in A2 show inches (millimeters) that it is 24 (609.6).

I know how to do it in separate cells but trying to combine it in one cell.

This is for approximately two hundred rows so I wanted to automate the formula.

 

[gaz_chops]

Welcome to the forum.

Use concatenate

=formula1&" ("&formula2&")"

 

[sheetspread]

You can concatenate with just the & sign

 

[SirCasak]

Works great, I was very close but not getting it just right.

Thank you - much appreciation

 

[gaz_chops]

You're welcome.