Combined if statements

[DCRAIG3389]

I have a spreadsheet that i want to create a part number that contains 4 parts. Ex 1rl9. The cell i want this to be in is blank. What formula do i use to make the second character in the blank cell = r?

[yay_excel]

I'm not sure exactly what you're asking.

[Sam Capricci]

Do the other parts come from different cells? If so you could use a concatenate formula like =A1&"r"&B1&C1 for example. If most of it is in another cell like 1l9 you could use a left and right formula and insert the item in the middle like this... =LEFT(A1,1)&"r"&RIGHT(A1,2)
without more specifics it is difficult to give you more.

[DCRAIG3389]

every part comes from a different cell. some are referencing combo boxes, others are just regular cells. Basically, in a blank cell i want to combine 4 parts and they have to be in the proper sequence.

[Sam Capricci]

Not sure if your reply means that the first part of my reply (using a concatenate) then wouldn't work.

[DCRAIG3389]

sorry, i know that there isn't much info. I attached a screen shot. i want to pull from from B1, B5, B6, and B7 to show in cell B10. i have linked the cells for the combo boxes so that isn't apic.jpgn issue.

[yay_excel]

The ampersand (&) concatenates data. If you know how to pull each individual piece of data from your worksheet, use & to link it together into one string.

[yay_excel]

To make the string contain an "r" without referencing a cell, use "r" in the formula, with the quotation marks.

[DCRAIG3389]

Thanks Everyone! Seems like the best way is to get the designator i want it a different cell and use the concatenate method to combine them all.

[Sam Capricci]

Could've sworn that is what I wrote in post #3. :roll eyes:

EDIT: BTW, thanks for the reputation bump DCRAIG.