Farah Mohammed
asked on
MID formula error?
I am trying to do a MID formula that looks at entries in a column and brings the information into a single cell. However, if the entry starts with an alph character, it will bring that back, but if the entry start with a numeral, it doesn't.
I have attached a copy of my spreadsheet.
Any ideas?
Thank you in advance.
Book1.xlsx
I have attached a copy of my spreadsheet.
Any ideas?
Thank you in advance.
Book1.xlsx
ASKER
Yes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Trying # 1 above - I forced column T as text, but the formula (F2) still didn't bring in T2.
See attached.
Book1.xlsx
See attached.
Book1.xlsx
ASKER
I mean T3....
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't mess around with cell formatting. The comparison operators override the formatting.
Kevin
Kevin
If you use <>"" that will work for everything except a NULL value, which isn't the same as "".
If you use >"" it will only work for strings.
If you use >"" it will only work for strings.
ASKER
I tried Kevin's formula above and it works.
Cluskitt - I don't think I need to worry about NULL values as the invoice number(s) will be manually entered.
Cluskitt - I don't think I need to worry about NULL values as the invoice number(s) will be manually entered.
To get a NULL value in excel, you'd have to force it. So yes, you don't have to worry about it :)
=MID(IF(T2<>"", " "&T2,"") & IF(T3<>""," / "&T3,"") & IF(T4<>""," / " &T4,"") & IF(T5<>""," / "&T5,""),1,15)
Kevin