Count Blank

[saurabh726]

Hi

Is there any formula by which i can count how many blank spaces are there before a text string in a single cell

For ex

help
figure

So if i wanna know how many blank spaces are there before help in single cell and how many blank spaces are there before figure in single cell how do i do that.??

Saurabh

 

[saurabh726]

well when i do that same thing happen but it counts blank a space too and it shows me sum 4 but still it does not get summed up and when i'll be back im definately got to do that.

CIAO logging out see u after three days jon

Saurabh

 

[saurabh726]

Hi,

Im still looking formula to sum up these values..

Well in a cell That contains a Number that is been extracted from a html report it shows me on formula istext(On that No)=True resulting the number does not get added up no matter whatever i do..paste values and multiply.

They dont get add up untill i overwrite the number figure on it.

Is there any formula for the same so that they get add up

the other =--trim formula is also not working it gives me end result as =!value..

Help me out

Saurabh

 

[Aladin Akyurek]

Hi,

Im still looking formula to sum up these values..

Well in a cell That contains a Number that is been extracted from a html report it shows me on formula istext(On that No)=True resulting the number does not get added up no matter whatever i do..paste values and multiply.

They dont get add up untill i overwrite the number figure on it.

Is there any formula for the same so that they get add up

the other =--trim formula is also not working it gives me end result as =!value..

Help me out

Saurabh

Post just 5 values.

 

[fairwinds]

Would not =SUM(VALUE(A1:A10)) (array entered) be worth a try?

 

[saurabh726]

Hi alaydin

I tried to download the value for the same it got downloaded but its not getting opening then it just ask me for enable and disable macro but it showed me the blank sheet without anything to it.

tell me how do u post the value..im quite new to this site

Thanx
Saurabh

 

[Aladin Akyurek]

Hi alaydin

I tried to download the value for the same it got downloaded but its not getting opening then it just ask me for enable and disable macro but it showed me the blank sheet without anything to it.

tell me how do u post the value..im quite new to this site

Thanx
Saurabh

No need for HtmlMaker. Post directly a copy of 5 cells with those dreaded characters.

 

[tusharm]

I could be wrong, but I get the impression that all you write in response to every person's attempt to help is, effectively, "It doesn't work."

You need to take the time and help all those who are volunteering their time to help you. Let's take one step at a time.

Suppose one cell that contains this mysterious non-number is A1.

In B1, enter the formula =LEN(A1). What do you get? Does that match the number of characters you see in A1?

Select C1:C{whatever number you have in B1}. Array-enter =CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
[To array enter a formula, complete data entry with CTRL+SHIFT+ENTER rather than just ENTER]

In D1 enter =CHAR(C1). Copy this down to cover all cells in C that have the array formula.

What are the results? Do you see where you have non-visible characters?

Now, in E1 enter =CLEAN(A1). Repeat the above process for E1, using columns F, G, and H. What are the results?

For the record, this discussion duplicates those in
http://www.mrexcel.com/board2/viewtopic.php?t=71961&highlight=
and
http://www.mrexcel.com/board2/viewtopic.php?t=71942&highlight=

 

[saurabh726]

No need for HtmlMaker. Post directly a copy of 5 cells with those dreaded characters.

if i copy paste here and then paste it to my excel file it get sumed up thats why im asking for a excel html maker so that i can copy there

Thanx
Saurabh

 

[saurabh726]

Hey ALAYADIN

I CAN EMAIL YOU THAT FILE GIVE ME UR E-MAIL ID AND I'LL EMAIL U RIGHT NOW.

Saurabh

 

[saurabh726]

What are the results? Do you see where you have non-visible characters

I see a non visible i cant see anything

Repeat the above process for E1, using columns F, G, and H. What are the results?

and i didnt understand what do u meant by this tushar and i certainly apperciate the other person help thats why no matter it works or not i try each and every single formula thats been told to me.

saurabh