Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Formula error

0

Hello,

I want to generate labels with a Letter and numbers

But seems when we are changing our letters we got a error

I have added a sample.

=TEXT(ROW(A1);"A-0000") 'A till Z

But for some reason we get #value! in our cells

If we change "A-" to some other letters

Thank you.

Answer
Discuss

Answers

0
Selected Answer

Timothy(?)

Not sure why that happens (something to do with non-formula cell formats I think) but you can fix it easily by moving the text part out of the TEXT formula i.e. using this (for column C say):

="C-" & TEXT(ROW(C1),"0000")
which will produce "C-0001" etc.

Row(C#) is the same as ROW(A#) so ="C-" & TEXT(ROW(A1),"0000") would do the same .

Discuss

Discussion

Awesome, Thanks John_Ru
GhostofWanted (rep: 46) Jun 24, '21 at 1:29 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login