Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
A1 B1-B200
concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
When you copy from A2 and paste it to a text document it should paste what
you see in A2... What is the formula you are using? What are the values in B1 and B2? "Aneka" wrote: A1 B1-B200 concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
When copying ensure you delete any absolute references eg. the $ (dollar
sign) before your reference eg $B$1 should be altered to B1 "Aneka" wrote: A1 B1-B200 concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
Yes, thank you. There are no absolute references in the formula.
"leerem" wrote: When copying ensure you delete any absolute references eg. the $ (dollar sign) before your reference eg $B$1 should be altered to B1 "Aneka" wrote: A1 B1-B200 concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
I am using the concatenate to write multiple SQL insert statements (sometimes
hundreds or thousands). =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B1,", 3073761)") The B column of my document contains all of the unique IDs. Normally, when I do the copying (usually I double-click on the square in the bottom right-hand corner of cell A1 and it copies to the end of the document) I don't have a problem. In the spreadsheet, I'm seeing this. In A2 =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B2,", 3073761)") In A3 =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B3,", 3073761)") However, when I copy/paste the results into the text doc, where I would normally see the expected B2 and B3 values, I'm seeing the B1 value. Any ideas in troubleshooting this are extremely appreciated! "Sheeloo" wrote: When you copy from A2 and paste it to a text document it should paste what you see in A2... What is the formula you are using? What are the values in B1 and B2? "Aneka" wrote: A1 B1-B200 concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
Are you sure calculation is automatic?
Check ToolsOptionsCalculation tab, Automatic -- Kind regards, Niek Otten Microsoft MVP - Excel "Aneka" wrote in message ... I am using the concatenate to write multiple SQL insert statements (sometimes hundreds or thousands). =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B1,", 3073761)") The B column of my document contains all of the unique IDs. Normally, when I do the copying (usually I double-click on the square in the bottom right-hand corner of cell A1 and it copies to the end of the document) I don't have a problem. In the spreadsheet, I'm seeing this. In A2 =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B2,", 3073761)") In A3 =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B3,", 3073761)") However, when I copy/paste the results into the text doc, where I would normally see the expected B2 and B3 values, I'm seeing the B1 value. Any ideas in troubleshooting this are extremely appreciated! "Sheeloo" wrote: When you copy from A2 and paste it to a text document it should paste what you see in A2... What is the formula you are using? What are the values in B1 and B2? "Aneka" wrote: A1 B1-B200 concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying concatenate not returning correct cell information
That was exactly it. It was set to manual. I knew it was just something
simple I was overlooking. Thank you very much. "Niek Otten" wrote: Are you sure calculation is automatic? Check ToolsOptionsCalculation tab, Automatic -- Kind regards, Niek Otten Microsoft MVP - Excel "Aneka" wrote in message ... I am using the concatenate to write multiple SQL insert statements (sometimes hundreds or thousands). =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B1,", 3073761)") The B column of my document contains all of the unique IDs. Normally, when I do the copying (usually I double-click on the square in the bottom right-hand corner of cell A1 and it copies to the end of the document) I don't have a problem. In the spreadsheet, I'm seeing this. In A2 =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B2,", 3073761)") In A3 =CONCATENATE("insert into #gs_entity_ad(entity_id, ad_id) values(",B3,", 3073761)") However, when I copy/paste the results into the text doc, where I would normally see the expected B2 and B3 values, I'm seeing the B1 value. Any ideas in troubleshooting this are extremely appreciated! "Sheeloo" wrote: When you copy from A2 and paste it to a text document it should paste what you see in A2... What is the formula you are using? What are the values in B1 and B2? "Aneka" wrote: A1 B1-B200 concat unique formula numbers I am using a concatenate formula in column A that uses column B as a variable. When I copy the formula down the spreadsheet, the formula reflects the cell change (from B1 to B2, for example). However, when I copy/paste the results of the formula from A2 into a text doc (which should contain the number in B2) it is retaining the number from B1. How do I rectify this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying information from one cell to another without modifying it. | New Users to Excel | |||
What formula do I use for copying cell information between workboo | Excel Worksheet Functions | |||
Copying Cell information | Excel Worksheet Functions | |||
vlookup is returning a value one cell above the correct cell. | Excel Worksheet Functions | |||
Comparing and copying information from one cell to another | Excel Worksheet Functions |