+ Reply to Thread
Results 1 to 4 of 4

Increment adding of cells with text values and spaces in between

  1. 06-13-2019, 09:00 PM #1
    MyStix01
    MyStix01 is offline
    Forum Contributor
    Join Date
    09-19-2017
    Location
    Taguig City, Philippines
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    120

    Increment adding of cells with text values and spaces in between

    Hi,

    I am trying to create increment numbers on my sheet and I was hoping to do it automatically. The thing is I cant just simply add 1 to the cell as there is a text value. Also, there are spaces in between, and the spaces varies from time to time.

    So I was hoping for a formula where it can just detect the last row value and add one to that without leaving the text part.

    In essence it goes like this, in cell A8

    A3 JE 1 (starting point)
    A4
    A5
    A6
    A7 JE 2 (add one from previous known value)
    A8
    A9
    A10 JE 3 (add one from previous known value)


    I have attached the sheet as well. In my sheet the formula =Row does not work as there are spaces in between so it is not counting correctly. I hope someone could help me out. Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-14-2019, 01:46 AM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Increment adding of cells with text values and spaces in between

    Try in A3 and fill down.

    =IF(D3<>"","JE "&COUNTIF($D$3:D3,"<>"),"")
    Dave
    Reply With QuoteRegister To Reply
  3. 06-25-2019, 07:55 PM #3
    MyStix01
    MyStix01 is offline
    Forum Contributor
    Join Date
    09-19-2017
    Location
    Taguig City, Philippines
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    120

    Re: Increment adding of cells with text values and spaces in between

    Hi FlameRetired,

    Thank you! This works perfectly.
    Reply With QuoteRegister To Reply
  4. 06-25-2019, 08:05 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Increment adding of cells with text values and spaces in between

    You are welcome. Glad it does the job.

    Thank you for the feedback, added rep and marking your thread Solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Not recognizing a value / adding values to array without spaces
    By Buzz1126 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2016, 01:04 PM
  2. Adding pre-text spaces to multiple lines in wrapped cell
    By Skoal in forum Excel General
    Replies: 9
    Last Post: 07-24-2015, 12:40 PM
  3. [SOLVED] Formula for Adding Spaces Before Text
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2014, 05:27 PM
  4. adding spaces to beginning text
    By Bilbo Baggins in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-07-2013, 02:20 AM
  5. Adding values of cells with similiar text
    By kuyleh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2012, 11:37 PM
  6. Adding spaces to text data in a cell
    By ParisFan43 in forum Excel General
    Replies: 1
    Last Post: 06-16-2011, 04:48 AM
  7. Adding spaces between certain text string
    By g_hadgraft in forum Excel General
    Replies: 1
    Last Post: 06-16-2009, 07:50 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1