Merging two cells (feet and inches) with the proper quotations added
I have 2 columns total. The first two columns are Feet and Inches (Width). I want to merge the first two columns together with proper quotations. Example: the first column has the number 1 and the second has the number 2. I want to merge these cells to become 1'2" . Can anyone help?? Thank you.
I saw this formula:
=INT(A1)&"' "&TEXT(12*(A1-INT(A1)),"# #/#")&CHAR(34)
I'm just not sure how to use this.
-Thank you.
If all you want to do is combine the 2 cells, then maybe something simple like....
=A1&"'"&B1&""""
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi parijoon and welcome to the forum,
See if this example helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
That formula would expect the feet and inches to be in the same cell, expressed as fractions of feet. In your case you can do this in C1:
=A1 &"'" & B1 & CHAR(34)
That might look right, but you won't be able to do any arithmetic on it.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks