+ Reply to Thread
Results 1 to 11 of 11

Excel 2007 : Adding Text To The Beginning of a column

  1. #1
    Registered User
    Join Date
    04-04-2011
    Location
    Australia
    MS-Off Ver
    Excel 200
    Posts
    12

    Adding Text To The Beginning of a column

    I have a list of items

    Canterbury
    Lyndhurst
    Ringwood
    Richmond
    Coldstream

    and I understand that I wanted to add text to the end the formula would be ="Courier "&A2 but how do I do it the other way around, I would like it to read,

    Courier Canterbury
    Courier Lyndhurst
    Courier Ringwood
    Courier Richmond
    Courier Coldstream

    Thanks so much for helping Regards Jodie

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Adding Text To The Beginning of a column

    What "Other way around" are you referring to?

  3. #3
    Registered User
    Join Date
    04-04-2011
    Location
    Australia
    MS-Off Ver
    Excel 200
    Posts
    12

    Re: Adding Text To The Beginning of a column

    using the formula as I have listed adds courier to the end of the list, but I want to add courier to the start of the list

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Adding Text To The Beginning of a column

    But you have "Courier" at the beginning of your formula. How can "Courier" become at the end?

  5. #5
    Registered User
    Join Date
    04-04-2011
    Location
    Australia
    MS-Off Ver
    Excel 200
    Posts
    12

    Re: Adding Text To The Beginning of a column

    Oh no, you are right, i have completely confused my self

    I want to have the courier at the end, the formula I have been doing puts courier at the start

    Thanks for your patience
    Canterbury Courier
    Lyndhurst Courier
    Ringwood Courier
    Richmond Courier
    Coldstream Courier

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Adding Text To The Beginning of a column

    So you have solved the problem?

  7. #7
    Registered User
    Join Date
    04-04-2011
    Location
    Australia
    MS-Off Ver
    Excel 200
    Posts
    12

    Re: Adding Text To The Beginning of a column

    no lol. that formula that i have entered above does it so it says courier first but I want to put courier at the end

    do you know what formula I should use?

    Regards Jodie

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Adding Text To The Beginning of a column

    =A2 & " Courier"
    Entia non sunt multiplicanda sine necessitate

  9. #9
    Registered User
    Join Date
    04-04-2011
    Location
    Australia
    MS-Off Ver
    Excel 200
    Posts
    12

    Re: Adding Text To The Beginning of a column

    awesome thank you, I dont know why it didnt work for me, maybe I have an extra space in or something thank you , thank you thank you

  10. #10
    Registered User
    Join Date
    04-04-2011
    Location
    Australia
    MS-Off Ver
    Excel 200
    Posts
    12

    Re: Adding Text To The Beginning of a column

    can you pls tell me how to make this post solved?

  11. #11
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Adding Text To The Beginning of a column

    Windley,
    If you go to your original post and hit edit>advanced you can select the prefix as solved.

    You have 1 day to do this then the thread self destructs......
    I may have just made that up.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1