Excel Questions

[Tony Baloney]

How do I add more columns (past IV) in Excel 2003?

The internet says 256 columns is max and I need to upgrade to 2007 or 2010. I don't like that answer.

[Hardy]

I wouldn't think it's possible.

[Orior]

That's one mother of a spreadsheet.

Sounds like it could be unusable - i  hope you're not planning to land it on some poor sod.

[Tony Baloney]

That's one mother of a spreadsheet.

Sounds like it could be unusable - i  hope you're not planning to land it on some poor sod.

Thankfully I'm not involved. Girl in my team is preparing data for data migration but in hindsight has made a hash of her spreadsheet as it has more columns than rows and has hit a wall at IV! If she did it the other way around she would have 200 columns and could then add rows to the cows came home. Ah well!

[thebigfella]

That's one mother of a spreadsheet.

Sounds like it could be unusable - i  hope you're not planning to land it on some poor sod.

Thankfully I'm not involved. Girl in my team is preparing data for data migration but in hindsight has made a hash of her spreadsheet as it has more columns than rows and has hit a wall at IV! If she did it the other way around she would have 200 columns and could then add rows to the cows came home. Ah well!

get her to do it again or can she not transpose the data?

[Hardy]

Yes - she should be able to transpose the data.

[saffron sam2]

Yes, copy the data, then Paste Special and ensure Transpose option is ticked.

[Orior]

Yes, copy the data, then Paste Special and ensure Transpose option is ticked.

I wish PhotoShop had a similar feature. Then we could copy pictures from the not safe for work thread, and paste with the Undress opton ticked.

[Tony Baloney]

Cheers lads just getting this now. Will get her to check it out tomorrow.

[Orior]

Any experts on at the minute in using INDEX(), MATCH() or LOOKUPs of various guises. This b***ard is going to beat me.

I didnt think there is much anyone can teach you boyo. The only tip I can offer with Lookups is to make sure your lookups are sorted.

[Hashtag]

Need help. I am currently running microsoft office 2010.

I need to add a conditional format on cells that if they are over 15 characters the cell will change colour.
Currently I am trying to add a new rule through conditional format:
=Len(A1)>15
format fill cell red.

However this is not working 

Ideas please?

[Hashtag]

Need help. I am currently running microsoft office 2010.

I need to add a conditional format on cells that if they are over 15 characters the cell will change colour.
Currently I am trying to add a new rule through conditional format:
=Len(A1)>15
format fill cell red.

However this is not working 

Ideas please?

Got it sorted. =Len(A1)>=15

[Atticus_Finch]

Hi folks,  can anyone advise me on a formula or a quick method on how i would turn the below info into whole numbers ?

Been playing about with RIGHT and LEFT function but no joy as of yet.

E.g. I would want the top line to be showing as 24 instead of d24:h21:m44:s27.
      I would want  the second line to be showing as 17 instead of d17:h02:m59:s50.

If anyone could help at all it would be very much appreciated.

cumulativeAge
d24:h21:m44:s27.
d17:h02:m59:s50.
d10:h04:m51:s19.
d08:h04:m28:s51.
d08:h04:m03:s06.
d07:h04:m47:s07.
d07:h04:m45:s04.
d06:h12:m56:s43.
d03:h05:m06:s02.
d02:h20:m57:s23.
d02:h19:m57:s08.
d02:h14:m19:s03.

[glens73]

=MID(A1,2,2)

[Billys Boots]

I'd have thought you'd need to get the cell into a number format and ROUND.