Text function will not TRIM!
for example
A1 = " unit message is message 19 + (P_TGT_WFI_QTY – U_INFLIGHT_AMNT) + message 2"
A1 also Equals IF(AQ4="",AM4,IFERROR(MID(AM4,1,AR4),AM4))
So it is a formula not a plain text
How do I get rid of the space infront of the A1 ( " unit.....")
TRIM FUNCTION DOES NOT WORK
Find out what the character is.
What result do you get with this formula:
=CODE(A1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Oh **** thank you I got it!
Why is there a ASCII space in my formula...?
Where does the data come from?
Does it come from the web? Web data is notoriously full of html "junk"!
so essentially and automated program
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks