enter before upper case word

[spirodem]

have a cell containing lots of text and i want to alt enter at the next start of upper case letter
Depth and fast sensing Medium energy to look like below
Depth and fast sensing
Medium energy

 

[Peter_SSs]

I cleaned up all the 300 W and now shows 300w
i have also fixed the Patented ID technology to show Patented-ID technology

So you have the code working fine now then?

 

[spirodem]

So you have the code working fine now then?

yes - thanks heaps

 

[spirodem]

that column is sorted
can i ask another question regarding another column in this thread or do i create a new post

 

[Peter_SSs]

If the next question is very closely related to this one you could continue here otherwise I would start a new thread as new thread get more "views".
You can always put a link in your new thread back to this one if this thread is relevant to answering the next one.

 

[spirodem]

that column is sorted
can i ask another question regarding another column in this thread or do i create a new po

If the next question is very closely related to this one you could continue here otherwise I would start a new thread as new thread get more "views".
You can always put a link in your new thread back to this one if this thread is relevant to answering the next one.

posted another