User Tag List

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Microsoft Excel help required

  1. #1
    Regular Member
    Join Date
    Mar 2007
    Location
    wrexham
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats

    Vehicle : Vectra c

    Trim : SRI Estate

    Engine : 1.8 VVTI

    Year : 06

    Default Microsoft Excel help required

    Evening all.

    Who's good with Microsoft Excel on here ? I require some help with a formula. I want to create a column of consecutive numbers with a letter preceding them eg R1 R2 R3 R4 etc up to R100. I can create 1 2 3 4 easily enough it's just that it doesn't like it when you add the letter to it. I keep getting VALUE #. Thanks in advance.

    A Jack in exile.

  2. #2
    Ex-Staff Full Member Taffyopel's Avatar
    Join Date
    Oct 2007
    Location
    Horley, Surrey
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Just tried it and it works ok for me.

    Typed R1, then to bottom right of that box until the '+' appeared then dragged down.

    Paul.


    Snowman, you got your ears on?

  3. #3
    Regular Member
    Join Date
    Dec 2007
    Location
    Darlington
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    There are a couple of ways depending on what you are using the data for... Easy way.. Create R1, R2 and R3 in the first three columns then select all three, then hover over R3 cell until you get a cross, at that point hit the mouse button and drag down 97 rows. This should give you R100

  4. #4
    Regular Member
    Join Date
    Dec 2007
    Location
    Darlington
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Beaten to it !

  5. #5
    Full Member spennny's Avatar
    Join Date
    Jun 2008
    Location
    Blantyre
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Yep what Taffy said, Box 1 type " R1 " , under neath it type " R2 "
    highlight both boxes and then in the second box, botom right, hold in the mouse key and drag it down

  6. #6
    Regular Member
    Join Date
    Mar 2007
    Location
    wrexham
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats

    Vehicle : Vectra c

    Trim : SRI Estate

    Engine : 1.8 VVTI

    Year : 06

    Default

    And it worked for me also. Thanks everyone for your speedy help . Gonna drink a Desperado in your honour now

  7. #7
    Regular Member mcwharam's Avatar
    Join Date
    Oct 2007
    Location
    Leeds
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Quote Originally Posted by siadwel View Post
    Gonna drink a Desperado in your honour now
    sorry off topic - where do you get your desperado's from. Last time I went to France really stocked the car up.

    All the internet companies want a fortune to deliver it.

    thanks

    Martin

  8. #8
    Regular Member
    Join Date
    Mar 2007
    Location
    wrexham
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats

    Vehicle : Vectra c

    Trim : SRI Estate

    Engine : 1.8 VVTI

    Year : 06

    Default

    Quote Originally Posted by mcwharam View Post
    sorry off topic - where do you get your desperado's from. Last time I went to France really stocked the car up.

    All the internet companies want a fortune to deliver it.

    thanks

    Martin
    PM'd you

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel help
    By shan in forum General Chat
    Replies: 11
    Last Post: 7th November 2007, 00:33
  2. Help Required with Microsoft Access
    By Merick in forum General Chat
    Replies: 4
    Last Post: 14th May 2007, 09:51
  3. MS Excel Experts
    By Damian in forum General Chat
    Replies: 4
    Last Post: 24th September 2006, 19:18
  4. Excel Help Please
    By jka in forum General Chat
    Replies: 15
    Last Post: 6th April 2006, 10:42
  5. Microsoft Excel Formula Problem
    By jka in forum General Chat
    Replies: 10
    Last Post: 13th November 2005, 14:15

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •