A
Akshay Bakhai
Am I
Regarding the blank rows, a nice way to clean them out and
still avoid IF statements is to use the TRIM and CLEAN
function. TRIM will replace multiple consecutive blanks
by a single blank; and CLEAN will remove all unprintable
characters.
If you are using a column number to look for your
information then maybe you need prudence before using
TRIM / CLEAN. Also, if you are using any non-printable
characters as delimiters to "tell" you where your
information is, then avoid using CLEAN.
Hope this helps a little bit.
Regarding the blank rows, a nice way to clean them out and
still avoid IF statements is to use the TRIM and CLEAN
function. TRIM will replace multiple consecutive blanks
by a single blank; and CLEAN will remove all unprintable
characters.
If you are using a column number to look for your
information then maybe you need prudence before using
TRIM / CLEAN. Also, if you are using any non-printable
characters as delimiters to "tell" you where your
information is, then avoid using CLEAN.
Hope this helps a little bit.