How to ignore a character in a formula?
For example:
B7 = FLS-105
C7 = SUM (B7/2)
C7 = #Value!
But if when I do this
B7 = 105
C7 = SUM (B7/2)
C7 = 52.5
I wanted to be able to enter the FLS- in front of the number in B7
Help.
Thank you.
How to ignore a character in a formula?
For example:
B7 = FLS-105
C7 = SUM (B7/2)
C7 = #Value!
But if when I do this
B7 = 105
C7 = SUM (B7/2)
C7 = 52.5
I wanted to be able to enter the FLS- in front of the number in B7
Help.
Thank you.
One way might be something like this:
=sum(MID(B7,FIND("-",B7)+1,LEN(B7)))/2
Why use sum when there's only one number??
=MID(B7,FIND("-",B7)+1,LEN(B7))/2
makes more sense.
I should add that my offering will only work if there's a hyphen between the text (which can be anything that's hyphen-free) and the number
Last edited by Glenn Kennedy; 12-08-2014 at 01:17 PM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
maybe this
="FLS-"&SUBSTITUTE(B7,"FLS-","")/2
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
what about attachment?
Here's the attachment.
Boss wants FLS- infront of the numbers in column B.
Please refer to my attachment below.
your attachment has numbers only. what happened to the letters?
How about this...
i meant my attachment
OMG!!!!! It worked! Thank you so much!!!!!
as a matter of interest, which one(s) worked for you??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks