char length question

jaypatel

Active Member
Joined
Nov 25, 2002
Messages
385
Hi

Is there a script that would look at say, column F, and if the number of character length is 3 or less, replace that number with 2100?

Thanks

Jay
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,099,508
Messages
5,469,034
Members
406,628
Latest member
jared92

This Week's Hot Topics

Top