combining columns all the way down

I am trying to combine two columns of information in excel but th
concatenate function doesnt seem to work for it. It may just be m
ineptitude in excel but I just cant seem to figure this out.

I have 3 colums

Column A__________Column B___________Column C
tree_______________ .jpg

But I cant seem to be able to make it so that column C has tree.jpg an
dog.gif and house.png

Is concatenate the wrong thing to use here? or am I making my formula

sparkroms's Profile:
View this thread:

7/8/2005 4:15:14 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies

Similar Articles

[PageSpeed] 2

Well, you didn't tell us what formula you are using, so we can only
guess that it is incorrect.

Try this in C1:


and copy this down your range of data.

Does that work for you?


swatsp0p's Profile:
View this thread:

7/8/2005 4:24:03 PM
okay I got that but now how do I concatenate text that has a quotatio
mark in it like the following html: <img width="76" height="25

sparkroms's Profile:
View this thread:

7/8/2005 4:37:54 PM
Again, you don't give enough info to us to give a certain answer.  I
the text you listed all in one cell?  Part in one cell, part i
another?  If not, are you trying to pull this text from within 
cell(s) that contains other text?

More info, please and give detailed examples of your data and expecte


swatsp0p's Profile:
View this thread:

7/8/2005 7:28:06 PM

Similar Artilces:

How do I set sent column to show recipient instead of sender
I have transfered all my email from outlook express (XP) to a new windows 7 computer running windows live mail. All is good except for the sent items list. It is showing myself instead of the recipient , why is this and is there a way to correct it ? Hi, viporpa. This should work in WLM just about as it always has in OE: Right-click on any column header, click Columns... and choose the ones you want. I see both From and To as options. Note that you may some differences between the columns in Mail from those in News. RC -- R. C. White, CPA San Marcos, TX rc@grandecom...

Multiple Columns in a stacked column chart
Is it possible to create multiple columns of stacked data sets? For example: can I plot monthly data in which each month is the sum of 3 categories, but plot these stacked columns for 2 years (side by side per month)? This enables me to compare last years monthly totals versus this years monthly totals on a per month basis? Justin - Through careful arrangement of the data in your worksheet, you can make a stacked column chart that looks like a clustered-stacked column chart. There is a tutorial showing this technique on Bernard Liengme's site:

Excel graph 3 sets of data. 2 sets as lines 1 as column?
I have data a bit like below, I am trying to do a graph, which shows the AFR as columns for A-D, but I want 'water' and 'whole' as seperate lines to show current scores across the graph. When I do the graph, I get two columns and 1 line. Does anyone know how to get to get the two lines? A B C D AFR 0.8 0.6 0.4 0.3 Water 0.5 0.5 0.5 0.5 Whole 0.3 0.3 0.3 0.3 Hi AndyN, On the chart, select the second column, right-click, select Chart Type from the context menu, select line chart. Ed Ferrero Ed Thanks for that worked a treat, I'll remember that ...

Column chart with both value x and y-axis
I was wondering if it is possible to define the x and y axes from two columns of data for a column chart. For example, I want the x-axis to be "Days Past Due" and the y-axis to be "Quantity" for a bar chart. When I try to do it now, it plots both sets of data as separate bar series and I want it similar to XY scatter but with colums instead. Thanks for any ideas or suggestions you may have. -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: ...

Stacked column charts that cross the X Axis
Hello I need to show a stacked chart for the budgets of companies A, B, C & D. As you can see, I have both positive and negative numbers. My graph starts both the negative and positive data at zero. I'm not an expert at graphs so the simpler the better. A B C D Budget =A30.313 -=A31.179 -=A32.055 =A31.1 Thank you very much for your time. Valerie - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - _______ "valerie&...

subtract column right from column left in excel?
How do I do entire columns with the same function, like subtraction? I have excel 2003. Question is unclear, please expand on what you want to do best wishes -- Bernard V Liengme Microsoft Excel MVP remove caps from email "Muffin" <> wrote in message > How do I do entire columns with the same function, like subtraction? > I have excel 2003. Hi, if what you mean is each row =B1-A1 if you mean the whole column =sum(B1:B60000)-sum(A1:A60000...

How do I link data in Excel 2000 from a column to a row?
I am trying to paste link of data on a sheet organized in a column to another sheet organized in a row. It does not seem to work by just copying and pasting link. Any help? Rich When your ready to paste, Right Click in the new location and choose "Paste Special", Then click on "Transpose", then <OK>. -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "rbenedict" <> wrote in m...

Summing the contents of one column based on the contents of another?
Hi again everyone, Ok, after I got several speedy and very helpful responses to my last query, I figured I could do worse than asking for help here again! Maybe when I learn some more I can help dish out advice instead of just asking questions! Here's my problem: I have a large spreadsheet with data in columns A and B. Column A contains lots of strings. Column B contains numbers. eg: Column A Column B Piano 4 Saxophone 5 Clarinet 12 Piano 2 Piano 6 Clarinet 1 Ok, what I want to do is g...

Is it possible to set a listbox column text to align right?
I have a listbox that has abount 14 columns. My client asked if I can make one of them (a money display with $ sign) to align right cos that makes it easier to read. I thought it is simple but it seems not possible. "yanguo" <> wrote in message >I have a listbox that has abount 14 columns. My client asked if I can make > one of them (a money display with $ sign) to align right cos that makes it > easier to read. I thought it is simple but it seems not possible. I haven'...

100% Stacked Column Chart Labels
I've created a chart with several 100% stacked columns, each having multiple data points in common. I'd like to show what percentage each of the data points is in relation to its column but the percentage data label is greyed out. Is there another way to do what I'm trying? Thanks! Hi, You can use this free add-in to link data label content to cells. In those cells you calculate the value you need to display. Cheers Andy jsv wrote: > I've created a chart with several 100% stacked columns, each having multiple >...

deleting every other cell in a column
I googled this question but am unable to understand how to use the programs (or scripts) offered as a solution. I am looking for a simple solution as I cannot program or use macro's. I want to delete every other cell in a column where the values in these cells happen to be the same three letters: QCO. (I found a solution for deleting every other cell where those cells had no value: Edit/Goto/Special/Blanks/Delete.) Is there a similar set of commands I could use in Excel to delete every other cell in a column where the value in those cells remains constant? thanking all in advance H...

Easiest way to write data to a file
I have a couple of macros that periodically act up. I say periodically, because some of the calculations are based on random numbers. I would like to have them write a few lines of debug data to a side file that I can examine after the macro completes. I wrote the Write2File subroutine below and the TestWrite2File routine to test it. It works except that it overwrites the previous data. How do I get it to append the data the the file? Are there any other improvements I should make to these routines? '***** Routine to test Write2File ***** Public Sub TestWrite2File() Dim...

What is the best way to block incoming email from a specific domai
I am wanting to start blocking incoming email from specific domains, but am not sure of the best way to do this. I am running Exchange 2003 SP2. Thanks, -- Midwest Muskie You can block mail from a smtp address/domain using Sender Filtering. If it's coming from a particular IP address/range, you can also use Connection Filtering/Global Deny list. -- Bharat Suneja MCSE, MCT blog: ----------------------------------------- "Mike" <> wrote in message news:0E1BAE53-B154-4CE6-8858-74749CB08047@microsoft.c...

Best way to format a flat file that Excel will load properly?
I'm generating a flat file in Outlook VBA. Right now I'm able to save it as a ..txt file, although I hope to save it in a delimited flat file format with an ..xls extension so it will automatically be opened by excel without having to go through the whole 'import' sequence. There are string fields in the file, some of which contain commas- so I can't make it a comma delimited file. What is the best delimiter to use so that Excel will automatically recognize and parse the flat file contents across columns? Currently in 2003, but strongly prefer solutions ...

Text to columns question
I have some data in the following format: Number firstname lastname schoolname The first three fields are one word each. Schoolname can be more than one word. I'm trying to parse the data using the data -> Text to Columns wizard, but I cannot figure out how to tell the wizard that there are only 4 space delimited columns in my data and not 5 for those instances where the schoolname is two words. Any help is appreciated. Thanks. On Jan 22, 9:50 am, MikeB <> wrote: > I have some data in the following format: > > Number firstname lastname schoolname >...

How to change Series Order in a Combination Chart?
I have 3 series of data in my chart: 1st two series are in a Stacked Column chart 3rd series is a Clustered Column Chart They are in the order as follows: Series2 Series1 Series3 I want to change the series order now as follows: Series2 Series3 Series1 I tried right clicking on my chart and went into Format Data Series - Series Order and change the Series order there. Nothing happens. Why is this not working? And, how do I change the series? Please help. P.S. I have gone through Jon Peltier's example and many other combination chart examples on the...

how to fit my column unmoved eventhough i scroll down?
how to make like for example i have column 1 until column 20 when i right scroll to column 8, it start to move to right hand side, and my first column can't see anymore. I want to be even though i scroll, the first column is not moving one.. no matter how i scroll, it can see the first column, how to set? which option? Hi - move the cursor in cell B1 - goto 'windows - Freeze Panes -- Regards Frank Kabel Frankfurt, Germany "Zxing" <> schrieb im Newsbeitrag > how to make lik...

Finally, an easy way to get rid of excessive default Excel 2007 styles Delete from "Select Case CurStyle.Name" to the "do nothing" line. It deletes all existing styles and resets them to the default Book.xlt. Not glamorous, but it works. ----------------------------------------------------------------------------- Less Spam Better enjoyable experience Visit : news:// Hi, So what's the question? Cheers, Shane Devenshire "sg" wrote: > > > Delete from "Select Case CurStyle.Name" to the "do nothing" line....

Easier Way to Refresh Pivot Table Data
I am looking for an easier way to refresh a pivot table (to avoid any complications with the PivotTable toolbar and to avoid the select/right click/refresh thing. Ideally I would be able to add the ! Refresh button directly into the file, but I don't know if I can do that. I guess it would be similar to adding a macro button for the refresh function. Any ideas? Thanks! If your Pivot Table is based on external data ... then you can use the Pivot table's options to update from the data automatically every n minutes. (The Pivot table's options are available by doing a right cli...

Independently set columns windows live mail (IMAP)
I'm having problems with the with windows live mail and the columns on my imap email account. If I change columns in the inbox the columns in the sent mail box changes to the also. How can I set the columns in each folder independently? I have no problems doing with with my pop account. Thanks in advance for any help. ...

Removing grid and column lines
i am trying to create an invoive in publisher 2003. Having a problem getting rid of the column and grid lines. It says to click on arrange and the go and change the grid lines to one but they are already at one and I can't seem to get rid of the lines. I would most certainly appreciate any help with this. Thank you Click on the table to select it. From the Menu click on Table > Table Auto Format > [None]. This removes any table and/or cell gridlines. dargill "BOB" <> wrote in message &g...

Is there a way to select all text boxes in a document?
I want to change the size of my document from a booklet on 11 x 14 paper to one page each on 8 1/2" x 11" paper. I can get the document to change to the 81/2 x 11 paper but the text boxes are still the smaller size (from the booklet). Is there a way to select all the text boxes at once so I can reformat their size? I want to make a large-print version of this booklet. Thank you for any help you can offer. Try the Painter tool. Quickly copy formatting with the Format Painter -- Mary Sauer MSFT MVP http://office.mi...

changing all email column names at once
I've been using outlook for about 2 months and I like to have the e-mail account name as one of the columns. Unfortunately I have a ton of folders and it looks to me like I have to change each folder individually. Is this true? Thanks Try making a new View that you then apply to each folder. -- Judy Gleeson - MVP Outlook Acorn Training and Consulting Canberra, Australia When you post in here, always include your version, SP level, and mode (if applicable) of Outlook - you can find this information in Help | About. Also include the type of mail account(s) you use and any other pertin...

Is there a way to disable Synchronizing Contacts Globally
We are testing the Outlook CRM Client and we have decided that we don't want our employees to synchronize the Contacts from CRM. Is there a way to globally disable this from either the server, when the clients installed, or through a registry change? you can stop them going offline through a security role ======================= John O'Donnell Microsoft CRM MVP "Dan N" <Dan> wrote in message > We ar...

Creating Combinations from Two Lists
I have data in two lists on two different worksheets. The data is laid out as: Worksheet A A B C Worksheeet B X Y Z I need to define the relationship between each element in a vertical setting, In the past I have used cut and paste but am hoping to write a macro that would create the relationships for me. For example: Col A Col B Col C A X A Y A Z X A Y A Z A Does anyone have any thoughts ...