How to trim the space in column B as per formula in red to achieve results in blue font figures
expected results should be 3456 EAcolumn a column b column c
3 456.00EA 3.00 3 456.00EA
that column B 3456 WITH NO TRAILING SPACE and column C EA
Using formula below
=TEXT(LOOKUP(99^99,--LEFT(AK14,ROW($A$1:$A$2132))),"0.00")
SUBSTITUTE(AK14,AL14,"")
Bookmarks