J
J.W. Aldridge
I have a macro that refreshes a web query. The data that it pulls
changes format quite often.
Is there any way to limit the number of characters pulled or shown in
a cell/column?
Example:
(In one column)
ABCDEFG
ABCDEFG
ABCDEFG
ABCDEFG
ABCDEFG
ABCDEFG
I only want the first four characters (without running a Left formula
in another column) in the column.
Example:
ABCD
ABCD
ABCD
ABCD
ABCD
ABCD
changes format quite often.
Is there any way to limit the number of characters pulled or shown in
a cell/column?
Example:
(In one column)
ABCDEFG
ABCDEFG
ABCDEFG
ABCDEFG
ABCDEFG
ABCDEFG
I only want the first four characters (without running a Left formula
in another column) in the column.
Example:
ABCD
ABCD
ABCD
ABCD
ABCD
ABCD