Hey I have about 1000 rows of data and I need to make a sentence for every row based on its information in its columns.
For example, I have
A B C
The car is green
how can I tell excel to put A + B + C (The car is green) in column D?
thanks
Hey I have about 1000 rows of data and I need to make a sentence for every row based on its information in its columns.
For example, I have
A B C
The car is green
how can I tell excel to put A + B + C (The car is green) in column D?
thanks
sorry it is
![]()
Please Login or Register to view this content.
regards
johnjohns
When you are not sure where to go, every road takes you there!
zsemago,
If the criteria for what color the car is is a combination of the letters A B and C in the exact order in columns A, B, and C respectively, then try this if I've interpreted your question correctly:
Create a table in range G1:G7 with the following data (ABC in column G, and Green in column H, etc)
ABC Green
DEF Black
HIJ White
KLM Blue
NOP Yellow
QRS Magenta
TUV Cyan
Put A in cell A1, B in cell B1, and C in cell C1
Then put the following formula in D1
![]()
Please Login or Register to view this content.
Regards,
Xrull
Xrull, sorry I did not provide all the details
Column A,B,C are more like Car, Green, Fast. So I would need to put the sentence together with extra words. The (A) is (B) and (C)
can u please post a sample workbook with the expected result
here it is.
Perhaps this way, if you are filling up all the relevant columns.
Thanks Johnjohns, this works nicely and I'll be using it.
However I am going to inevitably have another problem. There is some missing data in my excel file. For example I don't have commentary on all of the lakes, so the column F will be blank sometimes. I want excel to recognize column F has no data and therefore not even make a sentence about F. So sentence 3 only happens if column F has something in it. I would like this to happen with column E (species) as well.
Do you know how to do this?
May be this way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks