+ Reply to Thread
Results 1 to 4 of 4

change one word's number in ascending way along the column

Hybrid View

  1. #1
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    change one word's number in ascending way along the column

    hey friends,
    missed u all so much.
    i hope ur day is going on good.

    now i wanna ask my question.
    in attached file, u ll see and understand what i wanna do.
    i wanna make that word from ujdse1 to ujdse200

    can u help me please ?
    Attached Files Attached Files
    Last edited by aaaaa34; 05-01-2015 at 09:05 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,434

    Re: change one word's number in ascending way along the column

    One way:

    ="C: noip.us 29000 ujdse"& ROWs($1:1)&" cccam.com"

    Drag down and then copy/paste values.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: change one word's number in ascending way along the column

    tamam
    super buddy!!!
    thanks a lot!!!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,434

    Re: change one word's number in ascending way along the column

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how do I format a column to change color when another column has a specific word in it?
    By officegirl14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2014, 06:15 PM
  2. Formula to change a word to a number
    By henesey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2013, 10:01 PM
  3. How to change a number into word.
    By khokababu in forum Excel General
    Replies: 4
    Last Post: 04-16-2012, 06:19 AM
  4. Sort ascending before the word found
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2011, 09:17 PM
  5. Trying to change a code number into a word
    By moomog in forum Excel General
    Replies: 3
    Last Post: 09-16-2009, 08:13 PM

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