Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

EXCEL General number format

  1. Dec 2, 2011 #1
    I have an csv file that has a column of numbers in the form ab:cd:ef:ghy The cell's number format is general, I want to be able (if other criteria are met) to change y into y+1. The final column must again have the form ab:cd:ef:ghy and the number format general, can anyone out there give me an idea how to manipulate numbers in this format.
     
  2. jcsd
  3. Dec 2, 2011 #2

    I like Serena

    User Avatar
    Homework Helper

    What about "=MID(A1,12,1)"?
    This picks out "y",
    Then you can add one, perhaps after using "=N(value)".
    Finally you can concatenate everything with "=LEFT(A1,11)&C1".
     
  4. Dec 2, 2011 #3
    I like Serena
    Spot on, thank you, you have just out geeked our office resident geek who will now have to buy much beer, thanks again.
     
  5. Dec 2, 2011 #4

    I like Serena

    User Avatar
    Homework Helper

Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: EXCEL General number format
  1. Excel summing (Replies: 3)

  2. Excel + Calculations (Replies: 9)

Loading...