Extracting characters to the right of an equals sign from inconsistently formatted data -

[C Muth]

Hi, I am attempting to extract characters from the left and then separately from the right of an equals sign. The number of characters and positioning of spaces is inconsistent.

Below is an example of 3 records of data

1x44=44
3x2=6
4 x 5 = 20

Below is the desired results

Left Results
1x44
3x2
4 x 5

Right Result
44
6
20

The following is a simplified version of the formula which pulls the characters to the left



````Expr1: Trim(Left([Field1],(InStr(1,[Field1],"=")-1)))````

Have not been able to figure out how to do the same for the characters to the right of the equals sign.

Thanks!

[June7]

Trim(Mid(Field1, InStr(Field1, "=")+1))

[C Muth]

simple and works perfect, thank you!