Excel formula to word

S

Steved

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.
 
D

Deborah

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.
 
S

Steved

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...
 
G

Graham Mayor

Link the table from Excel and do your calculations in Excel.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0
List all tables, including document structure 0
Excel ignore formula 8
Print multiple booklet pages on 1 sheet 0
Vlookup and return sheet name also 2

Top