color-numbersout-help.xlsx
I need information from Column A to show on Column B WITHOUT the numbers in the format as shown in the attachment. As you can see Even the character BEFORE the number in column A should not populate in column B (example ROWS 7-8) the "Ju" is also not showing.
Thanks in advance!
with your data this works
Formula:
=TRIM(IF(ISNUMBER(LOOKUP(1,-MID(A1,ROW($1:$99),1),ROW($1:$99))),MID(A1,LOOKUP(1,-MID(A1,ROW($1:$99),1),ROW($1:$99))+2,255),A1))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
EXCELLENT!! thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks