| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check & Convert cell Value if condition auto
Hello,
Sheet 1, Column A is populated with Ref #s I would macro to check value and alter (if) according to below: LEN(VALUE) = 6 then "111"+VALUE LEN(VALUE) = 7 then VALUE VALUE already begins with "111" then VALUE I believe an event macro in sheet is route.... that is as far as i can take it. Any help appreciated, I've searched for awhile but solution found not. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto filter with condition | Excel Discussion (Misc queries) | |||
| Display in same cell lbs(kgs) using formula to auto-convert lbs | New Users to Excel | |||
| auto change cell text colour resulting from a condition | Excel Worksheet Functions | |||
| Continually check if condition is true in VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
