From: mgerken79 on 12 Apr 2010 15:41 Help please. I'm trying to combine text from multiple cells using the following formula. =B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3 Column I is where I am combining what is in these cells. The above cells contain formulas which I am using to QA certain data. They can return things like "Low Yield", "High Yield", and "Q" if the data meets the right conditions. I need the individual cells to return each of these possibilities, which include spaces, but I only want column I to combine the ones that are NOT "Q". Please let me know if you need more info to help. Thanks so much.
From: mgerken79 on 12 Apr 2010 16:09 Actually I don't want them to combine the blank cells either. So just ones that contain "High Yield" or "Low Yield". Is that possible? "mgerken79" wrote: > Help please. I'm trying to combine text from multiple cells using the > following formula. > =B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3 > > Column I is where I am combining what is in these cells. > > The above cells contain formulas which I am using to QA certain data. They > can return things like "Low Yield", "High Yield", and "Q" if the data meets > the right conditions. I need the individual cells to return each of these > possibilities, which include spaces, but I only want column I to combine the > ones that are NOT "Q". > > Please let me know if you need more info to help. Thanks so much.
From: Tom Hutchins on 12 Apr 2010 16:34 I'm not sure exactly what you want to see in your output. Try these: =SUBSTITUTE(SUBSTITUTE(B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3,"/ /","/ /")," Q "," ") =SUBSTITUTE(SUBSTITUTE(B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3,"/ Q /","/"),"/ /","/") Those are two separate formulas. They may have wrapped from being posted on the forum. Does one of them do what you want? Hope this helps, Hutch "mgerken79" wrote: > Actually I don't want them to combine the blank cells either. So just ones > that contain "High Yield" or "Low Yield". Is that possible? > > "mgerken79" wrote: > > > Help please. I'm trying to combine text from multiple cells using the > > following formula. > > =B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3 > > > > Column I is where I am combining what is in these cells. > > > > The above cells contain formulas which I am using to QA certain data. They > > can return things like "Low Yield", "High Yield", and "Q" if the data meets > > the right conditions. I need the individual cells to return each of these > > possibilities, which include spaces, but I only want column I to combine the > > ones that are NOT "Q". > > > > Please let me know if you need more info to help. Thanks so much.
From: mgerken79 on 13 Apr 2010 08:38 Tom This first equation is so very close. Thank you for the help. I'm sure I just want my cake and to eat it too, but this first equation changes the "Q" into blanks and I want it to return nothing. Is that possible? Thanks for the help. Mark "Tom Hutchins" wrote: > I'm not sure exactly what you want to see in your output. Try these: > > =SUBSTITUTE(SUBSTITUTE(B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3,"/ > /","/ /")," Q "," ") > > =SUBSTITUTE(SUBSTITUTE(B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3,"/ Q > /","/"),"/ /","/") > > Those are two separate formulas. They may have wrapped from being posted on > the forum. Does one of them do what you want? > > Hope this helps, > > Hutch > > "mgerken79" wrote: > > > Actually I don't want them to combine the blank cells either. So just ones > > that contain "High Yield" or "Low Yield". Is that possible? > > > > "mgerken79" wrote: > > > > > Help please. I'm trying to combine text from multiple cells using the > > > following formula. > > > =B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3 > > > > > > Column I is where I am combining what is in these cells. > > > > > > The above cells contain formulas which I am using to QA certain data. They > > > can return things like "Low Yield", "High Yield", and "Q" if the data meets > > > the right conditions. I need the individual cells to return each of these > > > possibilities, which include spaces, but I only want column I to combine the > > > ones that are NOT "Q". > > > > > > Please let me know if you need more info to help. Thanks so much.
From: Tom Hutchins on 13 Apr 2010 08:46 Is this it (I am still not sure what output you want)? =SUBSTITUTE(SUBSTITUTE(B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3,"/ /","//")," Q ","") Hope this helps, Hutch "mgerken79" wrote: > Tom > > This first equation is so very close. Thank you for the help. I'm sure I > just want my cake and to eat it too, but this first equation changes the "Q" > into blanks and I want it to return nothing. Is that possible? > > Thanks for the help. > > Mark > > "Tom Hutchins" wrote: > > > I'm not sure exactly what you want to see in your output. Try these: > > > > =SUBSTITUTE(SUBSTITUTE(B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3,"/ > > /","/ /")," Q "," ") > > > > =SUBSTITUTE(SUBSTITUTE(B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3,"/ Q > > /","/"),"/ /","/") > > > > Those are two separate formulas. They may have wrapped from being posted on > > the forum. Does one of them do what you want? > > > > Hope this helps, > > > > Hutch > > > > "mgerken79" wrote: > > > > > Actually I don't want them to combine the blank cells either. So just ones > > > that contain "High Yield" or "Low Yield". Is that possible? > > > > > > "mgerken79" wrote: > > > > > > > Help please. I'm trying to combine text from multiple cells using the > > > > following formula. > > > > =B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3 > > > > > > > > Column I is where I am combining what is in these cells. > > > > > > > > The above cells contain formulas which I am using to QA certain data. They > > > > can return things like "Low Yield", "High Yield", and "Q" if the data meets > > > > the right conditions. I need the individual cells to return each of these > > > > possibilities, which include spaces, but I only want column I to combine the > > > > ones that are NOT "Q". > > > > > > > > Please let me know if you need more info to help. Thanks so much.

Next

Last
Pages: 1 2 Prev: Counting with 2 criteria Next: Need to extract specific data from a text column 