I need an Excel formula that will separate the (-)negative symbol from a negative value in one cell e.g. -3, and put the symbol in a chosen cell and the number 3 in another. Also, If the number is positive have it do the same by putting a positive symbol in one cell and the number in another.
A1= -3 Desired Result= B1= -, C1=3
A1= 7 Desired Result=B1= +, C1=7
Any help greatly appreciated.