Excel formula to word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello from Steved

Below is an excel formula for 15 characters
What formula would I write please in word

=IF(LEN(A2)>15,LEFT(A2,15),A2 & REPT(" ",15-LEN(A2)))

Thankyou.
 
Word has very limited capabilities when it comes to formulas and I don't
think you will be able to get it to calculate this complex formula. It is
mostly for simple addition/subtraction.
 
Thankyou.

Deborah said:
Word has very limited capabilities when it comes to formulas and I don't
think you will be able to get it to calculate this complex formula. It is
mostly for simple addition/subtraction.
Click to expand...
 
Link the table from Excel and do your calculations in Excel.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top