| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel formula to word
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. |
|
#2
|
|||
|
|||
|
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. "Steved" wrote: 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. |
|
#3
|
|||
|
|||
|
Thankyou.
"Deborah" wrote: 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. "Steved" wrote: 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. |
|
#4
|
|||
|
|||
|
Link the table from Excel and do your calculations in Excel.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Steved wrote: Thankyou. "Deborah" wrote: 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. "Steved" wrote: 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. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Word 2003 documents to WordPerfect formate | Microsoft Word Help | |||
| creating forms | Microsoft Word Help | |||
| how can you create quickwords in MS Office Word 2003 | Microsoft Word Help | |||
| copying files from Wordperfect to Microsoft Word | New Users | |||
| formatting links from excel into word (extra line feeds) | Microsoft Word Help | |||
Linear Mode
