0

I have a simple formula in my excel sheet that lists, horizontally the number of days in a sequential fashion:

=A1+1

A1 contains a zero (0).

As such, the formula then adds one for each subsequent cell on the row, producing 1, 2, 3, 4, etc.

What I would like to do is be able to prepend a text character, "+ " into each cell's formula.

Is this possible?

  • Have a look at the concatenate function. – spikey_richie Aug 22 '19 at 15:05
  • Thanks, spikey! I'm aware of the concatenate, but I get an error when I use that because once the + is added to the cell, the subsequent functions no longer work. Ideas? – Ashy Aug 22 '19 at 15:14
1

Instead of =A1+1, etc, have ="+" & A1+1

enter image description here

| improve this answer | |
  • That did it!! Thanks! – Ashy Aug 22 '19 at 16:45
1

Concatenating a + symbol onto a numeric result renders the result mathematically useless.

Use a custom number format of +0 and you will retain the numeric value in the cell, not text that looks like a number.

| improve this answer | |
  • 1
    This is the "correct" answer. – Andreas Aug 23 '19 at 11:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.