word format

[hktom]

dear sir

we copy from website and the word cannot identify by my vba code formula.

That is vba code can identify by the word format of "write by hand" but cannot identify by word format of "word
copy from website"

pls help how to use vba code to change word format of "word copy from website"
to word format of "write by hand"

--------------------------------------------------------------------
Remark"
when we use the mouse put in A2 ,put the mouse at 550 the back,press delete,it become 550(write by hand)
same formatting.
---------------------------------------------------------------------
attached file it is only small part of the data which ask for help. actually it contain many data in sheet1

Thanks
Tom

[jason.b75]

No vba needed.

In Excel, press Ctrl h

Click in the top box (the one that says 'Find What:')

Hold down the 'Alt' key, and while you're holding it, type 0160 using the number pad on the right side of your keyboard.

** You must use the number keys on the right, if you use the ones at the top of the keyboard it will not work!! **

Make sure that the bottom box ('Replace With:') is empty, and click the 'Replace All' button.

[hktom]

thanks jason..

Will we follow bellow steps?
1.when the box show "find and replace",
2.press (=hold down) 'alt' key , type 0160 on right side of keyboard( but it dont show any word which
we type in "find what" ....). that mean we done nothing ...

pls help
Thanks
Tom

[jason.b75]

2.press (=hold down) 'alt' key , type 0160 on right side of keyboard( but it dont show any word which
we type in "find what" ....)

This is correct! You cannot see that which is not visible!

If you had made the effort to click the button as instructed, you would see that it does what you need.

Try again, press 'Ctrl h', then click 'Replace All', ** Do Not re-type the 'Alt 0160' sequence! ** The character should still be there from your earlier failed attempt.

If it doesn't work, then try repeating all steps as described in post #2.

[hktom]

thanks jason i try but still fail ....

dear all

do we have vba code to delete the last space in cell ?

thanks
tom

[hktom]

i find from other ,
the code is similar to follows?

Please Login or Register  to view this content.

but it don't work. pls help and modify
thanks
tom

[jason.b75]

If the procedure I suggested failed then that is down to the way it was used. It works fine for me on your test file. If you really want it in vba then you can get that from the macro recorder.

Trim will not work because the extra character you have is not a space, although it might look like one.

Did you have more than one cell selected when you pressed 'Ctrl h'? If so that is probably the cause of the failure.

If a single cell is selected, then find and replace applies to the whole sheet, if more than one cell is selected, then it only applies to the selection.

[hktom]

sorry jason , i think i need use vba code ..

i find other information, because i am very fresh for vba

Please Login or Register  to view this content.

but it still dont work...pls help
thanks
tom

[jason.b75]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[hktom]

thanks jason ...actually my english is not so good and dont understand the rules ...anyway i believe
can use your methods before. the problems is solved

[jason.b75]

actually my english is not so good and dont understand the rules

Language is no excuse, have a look here, see if you understand one of these versions.

http://www.excelforum.com/forums-rules/

If you correctly tag the code in post #8 then I will provide a vba solution for you (it only needs one line).