Is there a formula to change import a hypen between height measurements.

[JERRY_MD]

I am trying to locate a formula that can import an apostrophe to properly format the appearance of height measurements in a column?

 

[VoG]

Can you give some examples of what your data looks like.

 

[JERRY_MD]

The data is within columns "505" I'm trying to present the data as such "5'05"

 

[VoG]

This will work for that example

=LEFT(A1,1)&"'"&RIGHT(A1,2)

 

[JamesW]

Without seeing what you are looking at it's hard to give an answer.

Have you tried the & sign? (<FORMULA HERE>&"'") - There is an apostrophe in the middle of 2 speech marks there.

 

[JERRY_MD]

Thank you