I need a formula that brings back a set amount of information when there are
variable amounts of information in the selected cell. I am working in a
spreadsheet where column a has numbers of different length. I am trying to
create a formula that brings back a variable amount of information. In some
cases I would need the first four digits brought back, in others the first
five digits, and so on.