Share via

Formula Help?

FunWith Stencils 1 Reputation point
2020-12-15T21:01:34.493+00:00

I am making an array of SKUs and at the end of the SKU the first one for example would be: TG1974TNCA . Is there a way that I can copy the original SKU (dragging that cell down to the other 5 cells) but it will automatically change the last letter to the next letter in the alphabet? i.e. next cell would be TG1974TNCB next cell would be TG1974TNCC . I have HUNDREDS of these to copy and dont want to sit there and type each one when it is just the last letter needs to change.. THANKS!

Microsoft 365 and Office | Excel | For business | Windows
Community Center | Not monitored

2 answers

Sort by: Most helpful
  1. Herbert Seidenberg 1,201 Reputation points
    2020-12-24T19:05:56.977+00:00

    Was this answer helpful?

    0 comments No comments

  2. Emi Zhang-MSFT 30,196 Reputation points Microsoft External Staff
    2020-12-16T07:27:41.643+00:00

    Hi @FunWith Stencils ,
    Please try this formula:

    ="TG1974TNC"&CHAR(64+ROW(A1))

    48530-262.png


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.