Try Left ( Dimension ; 2 ) & "\" x " & Middle ( Dimension ; 3 ; 2 ) & "\" x "& Right ( Dimension ; 2 ) & "\"H"
Note that back slash and double quote just before the H that was added.
I added the "\"H" but no luck, I am wondering if it has something to do with the field itself
Please keep in mind that this formula will only work if each of the three dimensions is in the range 10 - 99.
Just one dimension outside this range will cause the formula to produce an erroneous result.
Please check your data to see if this has happened.
Best wishes - Alan Stirling - London UK
I have checked data, I do have all records showing W00 x D00 x 22H and have cleaned out any data that had a different format but still doesn't work
I have solved the problem by unchecking the box that says Do Not replace existing value of field (if any)
I probably would have made this a stored calclulation field instead of an AutoEnter text field. Just my 2 cents.