How can I get =Clean and =Proper Case to run on all cells in a col

G

George

I have 3 columns (K, L, M) that we paste text into from other soucres. The
text that's pasted is sometime all caps, hence the reason for the "Proper
Case" Function and additionally the pasted text contains hard returns that
need to be remove so that it reads correctly, hence the "Clean" function.

I would like for this to happen as soon as the text is pasted into the cell.

Thanks for your help in advance,
Coyote
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Macro using CLEAN & PROPER on a worksheet. 1
macro to run a function with select case to open an Excel spreadsheet 4
ADD Change Case function from Word to Excel 2
if val in col3 is one of 13 codes (list), apply factor to val in c 1
How can I use one formula to change case on an entire worksheet? 2
Insert a semicolon in lieu of ALT Enter 4
using an IF or AND function to get next largest value in list 1

Top