Become a supporter to remove this ad

User Tag List

+ Reply to Thread
Results 1 to 13 of 13

Thread: Excel help: mixing data into a string

  1. #1
    Member Sentry's Avatar
    Join Date
    Jul 2007
    Location
    -
    Motorbike
    -
    Liked
    0 times
    Posts
    4,904
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Excel help: mixing data into a string

    Hi guys,

    I tried searching in Google but all I found was porn.

    ...anyway I need to know how to insert data into a text string.

    For instance:

    =??? ( "This is the text and the data is" & C14 & "the text continues")

    Any help is much appreciated. Have a massive assignment I need to do and this would help out immensely

    "Always out-numbered, never out-gunned"

  2. #2
    Nath's Avatar
    Join Date
    Feb 2004
    Location
    PSB Café
    Motorbike
    pink r1200gs
    Liked
    28 times
    Posts
    13,717

    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    Member Murley's Avatar
    Join Date
    Jan 2008
    Location
    Perth, Western Australia, Australia
    Motorbike
    THE SMURF
    Liked
    35 times
    Posts
    3,768
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Concatenate?

    =concatenate("This is the text and the data is",C14,"the text continues")

    I think...

    Edit: Beaten by Nath...

  4. #4
    Member xphread's Avatar
    Join Date
    Jun 2006
    Liked
    2 times
    Posts
    2,831
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    =CONCATENATE("text1",C14," text 2")

    Hope that helps

    -edit damn... blink and you are beaten.

  5. #5
    Member Sentry's Avatar
    Join Date
    Jul 2007
    Location
    -
    Motorbike
    -
    Liked
    0 times
    Posts
    4,904
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cheers all.

    I've found out that you can just type:

    ="string here"&C43&" more text"

    Been a while since I've used excel. Never heard of concatenate though but hey, if it does the same thing

    "Always out-numbered, never out-gunned"

  6. #6
    Member TORQ's Avatar
    Join Date
    Apr 2007
    Liked
    1 times
    Posts
    6,005
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ^^ exactly. Don't need a function for it.

  7. #7
    Member Tuscadero's Avatar
    Join Date
    Jul 2006
    Location
    SOR
    Motorbike
    '04 GSX-R600
    Liked
    0 times
    Posts
    2,874
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmmmm...
    I am going to be needing some help with Excel and was wondering if the good people of PSB would be able to assist.
    Will post up questions later.
    Why be difficult?
    Put some effort into it and be IMPOSSIBLE !

  8. #8
    Member TORQ's Avatar
    Join Date
    Apr 2007
    Liked
    1 times
    Posts
    6,005
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Post Away. Or hit F1 first. Then Post

  9. #9
    Member Tuscadero's Avatar
    Join Date
    Jul 2006
    Location
    SOR
    Motorbike
    '04 GSX-R600
    Liked
    0 times
    Posts
    2,874
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    F1 isn't helping
    Why be difficult?
    Put some effort into it and be IMPOSSIBLE !

  10. #10
    Member TORQ's Avatar
    Join Date
    Apr 2007
    Liked
    1 times
    Posts
    6,005
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Conditional formatting stuff still ?

  11. #11
    Member Tuscadero's Avatar
    Join Date
    Jul 2006
    Location
    SOR
    Motorbike
    '04 GSX-R600
    Liked
    0 times
    Posts
    2,874
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No, have sorted the conditional formatting.

    Can anyone that is excel -macro/vba savvy please tell me how I get a cell link from one workbook to auto update to the relevant cell in another worksheet? It is not static.

    For example:
    Range("B7").Select
    ActiveCell.FormulaR1C1 = _
    "='Q:\WOH Statistics\[VAP Claims Received.xls]2009-2010'!R[-2]C2"
    Range("B7").Select

    I want R[-2]C2 to change each time the macro is run. Next time I want it to be R[-1]C2, then R[0]C2. In other words I want it to move.

    Yes I am not au fait with all this and would appreciate help. The whole macro works, except for this one element.
    Why be difficult?
    Put some effort into it and be IMPOSSIBLE !

  12. #12
    Member Pkunk's Avatar
    Join Date
    May 2006
    Liked
    0 times
    Posts
    7,305
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Keep a counter in a random cell and reference that instead?

    Seems like you need some serialised data

  13. #13
    Member Matso's Avatar
    Join Date
    Feb 2008
    Location
    Ina Psychiatric Ward
    Motorbike
    50cc Quadard
    Liked
    0 times
    Posts
    245
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Tuscadero View Post
    No, have sorted the conditional formatting.

    Can anyone that is excel -macro/vba savvy please tell me how I get a cell link from one workbook to auto update to the relevant cell in another worksheet? It is not static.

    For example:
    Range("B7").Select
    ActiveCell.FormulaR1C1 = _
    "='Q:WOH Statistics[VAP Claims Received.xls]2009-2010'!R[-2]C2"
    Range("B7").Select

    I want R[-2]C2 to change each time the macro is run. Next time I want it to be R[-1]C2, then R[0]C2. In other words I want it to move.

    Yes I am not au fait with all this and would appreciate help. The whole macro works, except for this one element.
    Just to be clear Tuscy

    You want the new set of data to be set above the latest row of data?

    Matso

+ Reply to Thread

Similar Threads

  1. Getting into audio mixing - any help?
    By harns in forum Yada Yada Yada
    Replies: 32
    Last Post: 14-07-2009, 01:05 PM
  2. G-String
    By Dwight in forum Funny Stuff
    Replies: 5
    Last Post: 31-10-2007, 01:04 PM
  3. Angelina Jolie's g-string
    By sarcasmatron in forum Funny Stuff
    Replies: 1
    Last Post: 17-06-2005, 06:09 PM
  4. Mixing tyres
    By Ryder in forum General Bike Talk
    Replies: 7
    Last Post: 20-04-2005, 03:04 PM

Bookmarks

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

Content Relevant URLs by vBSEO 3.6.0