concenate

Hello I have 7 columns of data spanning 3077 rows and I have concenated it to one column to read as an address with phone number and website..each of these having a title in the concenate formula. I need to transfer this data to a CVS form to upload into a map however when I try it reads data as...

SO I have data on an excel spreadsheet that looks like this below, with one questions vertically after another. How do I merge the data per question separately? Please let me know! Thanks guys! #1 Whichofthe following is the paramount objective of financial reporting by state and local...

Hi Again, Struggling to come up with a solution to the following. Im looking to create an IF formula for the following situation. If another worksheet has the same value as the current worksheet then display the corresponing cell value of the other worksheet that lies in that row. The range...

Hey All, I would have a basic question. I have a 2 sheets that have more columns, I want to do a VLOOKUP, but based on two cells. The target table where I search has also two columns, which give the clear identification. Can I use VLOOKUP without putting an extra Concenate column or using & " "...

I merged two columns..............so now i dont need the first two columns. How can I keep the information in the merged column and get rid of the first two that are repetitive now that i have the merged column. Without messing up the formula stuff in the concenated column. I need to...