Length and width from four columns to one

**Christopher Lynch** · 02-19-2013, 05:39 PM

Hi all,

I've recently come upon a spreadsheet that has four columns thus: width feet, width inches, length feet, length inches. There is a fifth column with the length and width formatted traditionally (x'y" x a'b"). Is there a formula I could put in the fifth column ("Size" below) to just grab the data from the other four and put it in the right format? Thank you and let me know if this isn't clear.

Width (ft)	Width (in)	Length (ft)	Length (in)	Size
4	7	6	10	4'7" x 6'10"
2	10	7	3	2'10" x 7'3"
2	11	7	2	2'11" x 7'2"
8	0	10	6	8' x 10'6"
14	3	16	11	14'3" x 16'11"
2	1	3	1	2'1" x 3'1"

**TMS** · 02-19-2013, 05:49 PM

Try:

Cell E2: =A2&"'"&IF(B2<>0,B2&"""","")&" x "&C2&"'"&IF(D2<>0,D2&"""","") and drag down

Regards, TMS

**Christopher Lynch** · 02-19-2013, 05:54 PM

TMS,

Thank you, that's a beautiful formula, it works perfectly.

Chris

**TMS** · 02-19-2013, 06:34 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

**Christopher Lynch** · 02-19-2013, 07:25 PM

Thank you again! That's good to know.

Cheers,
Chris

**TMS** · 02-19-2013, 07:30 PM

Again, you're welcome. Thanks for the rep.

You're table showed an example of "not showing inches" ... so that's what I did

Cheers

Length and width from four columns to one

LinkBack

Thread Tools

Rate This Thread

Display

Length and width from four columns to one

Re: Length and width from four columns to one

Re: Length and width from four columns to one

Re: Length and width from four columns to one

Re: Length and width from four columns to one

Re: Length and width from four columns to one

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions