Excel Questions

[Tony Baloney]

I googled it. Cheers anyway. Sorted.

[Billys Boots]

In cell C1, put =A1&TEXT(B1,0).  Copy down the way.

[thebigfella]

How many ways can come up with to solve the same problem?

[Orior]

I hope this is easy...

I want to be able to merge data from 2 columns into one column.

i.e.
Column A = Document Reference        e.g. BD001
Column B = Document Revision           e.g. Rev.1

I want to merge both into a single column i.e.
Column C = Document Reference + Document Version e.g. BD001 Rev.1

Help would be really appreciated as I have about 1000 rows!

Or =A1 & " " & B1

Ampersand is a great word.

I'm thinking of calling my next child "Ampersand", middle name Dot. And when she married Joe Barr, her email address will be

&.@|

[brokencrossbar1]

I hope this is easy...

I want to be able to merge data from 2 columns into one column.

i.e.
Column A = Document Reference        e.g. BD001
Column B = Document Revision           e.g. Rev.1

I want to merge both into a single column i.e.
Column C = Document Reference + Document Version e.g. BD001 Rev.1

Help would be really appreciated as I have about 1000 rows!

Or =A1 & " " & B1

Ampersand is a great word.

I'm thinking of calling my next child "Ampersand", middle name Dot. And when she married Joe Barr, her email address will be

&.@|

You get stranger and stranger!

[muppet]

I hope this is easy...

I want to be able to merge data from 2 columns into one column.

i.e.
Column A = Document Reference        e.g. BD001
Column B = Document Revision           e.g. Rev.1

I want to merge both into a single column i.e.
Column C = Document Reference + Document Version e.g. BD001 Rev.1

Help would be really appreciated as I have about 1000 rows!

Or =A1 & " " & B1

Ampersand is a great word.

I'm thinking of calling my next child "Ampersand", middle name Dot. And when she married Joe Barr, her email address will be

&.@|

You could call him Dubya.

Then it would be W Orior.

Cool.

[Orior]

I have 10 sheets in my workbook (Coversheet, sheetA, SheetB, SheetC etc)

I want the contents of a cell CoverSheet to be the value of cell A1 in another sheet. The name of the other sheet is held in cell B2.

I was trying the following formula:

CONCATENATE("='",B1,"'!A1") but it does not work. Any ideas?
 

[mylestheslasher]

=CONCATENATE("=",B1,"!","A1")

[Orior]

=CONCATENATE("=",B1,"!","A1")

It does not recognise the contents of B1 as another worksheet.

I tried putting two single apostophes around B1, but that doesnt work either.

[Mac hinery]

=CONCATENATE("=",B1,"!","A1")

It does not recognise the contents of B1 as another worksheet.

I tried putting two single apostophes around B1, but that doesnt work either.

I think you need to use full reference to the worksheet and cell e.g. =CONCATENATE("=",sheeta!B1,"!","A1")

[thebigfella]

I have 10 sheets in my workbook (Coversheet, sheetA, SheetB, SheetC etc)

I want the contents of a cell CoverSheet to be the value of cell A1 in another sheet. The name of the other sheet is held in cell B2.

I was trying the following formula:

CONCATENATE("='",B1,"'!A1") but it does not work. Any ideas?

Give me a better example, concatenate only joins 2 or more strings together. I don't think it is what you want to do.

[gerry]

i will put this on the torrent tread as well but anyone looking windows office here is is one that is easy to install and works a treat


http://thepiratebay.org/torrent/5426553/Microsoft_Office_2007-_Full_Package_-_Easy_Install_-_Unlimited_l

[Maiden1]

I think you can use the INDIRECT function in excel

So if you wanted the contents of Sheeta!A1 you could use

=INDIRECT("Sheeta!A1")

Or in your case you would want

=INDIRECT(B2&"!A1")

[illdecide]

I'm using excell to put all the lads numbers and email address into but when i put 0 (zero) in for their mob number in deletes the 0 why is this

[Mhic Easmuint]

I'm using excell to put all the lads numbers and email address into but when i put 0 (zero) in for their mob number in deletes the 0 why is this

Format the cells as text