Skip to Main Content
WordPerfect Office Ideas Portal
Created by Mark Weiland
Created on Apr 17, 2022

Convert Excel Formula Wizard

Similar to a find and replace dialog box, have the ability to copy in an Excel formula and have the formula converted to Quattro Pro format for pasting into QP.

For example, if you have a formula in Excel that let you start with AAA in cell A1 and get a number of values incrementing by 1. So the next would be AAB, AAC, etc.

Excel Formula in A2 that can be copied down the column to increment the value: =IF(RIGHT(A1)<"z",LEFT(A1,2)&CHAR(CODE(RIGHT(A1))+1),IF(MID(A1,2,1)<"z",LEFT(A1)&CHAR(CODE(MID(A1,2,1))+1)&"A",CHAR(CODE(LEFT(A1))+1)&"AA"))

QP Formula:

@IF(@RIGHT(A1,1)<"z",@LEFT(A1,2)&@CHAR(@CODE(@RIGHT(A1,1))+1),@IF(@MID(A1,2,1)<"z",@LEFT(A1,1)&@CHAR(@CODE(@MID(A1,2,1))+1)&"A",@CHAR(@CODE(@LEFT(A1,1))+1)&"AA"))

It would be nice if there was a wizard where I could copy the Excel formula and have the @ signs put in and the extra default parameters put in for RIGHT and LEFT.

Or perhaps simply support Excel formula syntax.

  • Attach files