Forum Discussion

HP_ELITE_8300's avatar
HP_ELITE_8300
Copper Contributor
Jul 30, 2021

Column numbers with text

I want to fill column with next+1 cmd A1 K101 A2 K102 A3 K103 etc Formular  A4 A3+1 A5 A4+1  A6 A5+1 etc answer should be A1 - A6 K101 - K106 A1+1 Function does not handle Text in the next ...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 30, 2021

HP_ELITE_8300 

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

HP_ELITE_8300's avatar
HP_ELITE_8300
Copper Contributor
Jul 30, 2021
Answer is not really what I want
just want to use the A1+1 down the column with text contents
value in A1 is K101 the value in A2 should be K102 an so forth
value in A1544 should be K1544 - can't add mixed text and numbers?
I don't like forums I need direct answers Jdanteague@att.net
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 30, 2021

    HP_ELITE_8300 

    You will probably need a custom counter, the alphanumeric is not incremented that way. Alphanumerically, it would have to count up from A1 K101 to A1 K102 and not A2 K102.

    In the attached file there are some examples,

    but I am almost sure that this is not what you are looking for.

     

    With your permission, add a file (without sensitive data),

    explain on the basis of this file what exactly you want to accomplish.

    So you get a proposed solution that suits your needs.

     

    Thank you for your patience and time.

     

    Nikolino

    I know I don't know anything (Socrates)

     

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Jul 30, 2021

    HP_ELITE_8300

    Assuming value in A1 is K101 then try this...

    In A2

    =LEFT(A1,1)&MID(A1,2,255)+1

    and copy it down.

    Does it work for you?

Resources