Posted to microsoft.public.excel.misc
|
|
Help with formula
If no:
=if(mid(b2,2,3)="123", ....
Oopsie!
Dave Peterson wrote:
Do you know what that box character is?
If no:
=if(mid(b2,3)="123", ....
If yes, include it in your test.
Chip Pearson has a very nice addin that will help determine what that
character(s) is:
http://www.cpearson.com/excel/CellView.htm
=if(left(b2,4)=char(10)&"a/r", ....
replace char(10) with the code you find using Chip's addin.
Jim May wrote:
I've imported a text file and I'm testing some of the fields, like:
If(Left(B2,3)="A/R","",B2)
One of the cells in column B contains - in the 1st position the square
Box
Character, then 1234, sorta like x1234 (where x is the square box
character)
How can I incorporate this character into my above formula?
Tks in advance...
--
Dave Peterson
--
Dave Peterson
|