I have a text in multiple cells with varying lengths and number of words or numbers. I need to truncate each word, say to the first three characters, so the total lenght is no more than 25 characters. I am not sure how the TRIM, TRUN, LEFT, RIGHT or other defined functions might apply. A UDF might be best.
Examples
CONSTRUCTION SEQUENCING AND PHASING COMPOSITE PLAN
CON SEQ AND PHA COM PLA
ALIGNMENT HORIZONTAL CONTROL COMPOSITE PLAN
ALI HOR CON COM PLA
TEMPORARY ROADWAY NO. 4 ALIGNMENT DATA TABLES
TEM ROA NO. 4 ALI DAT TAB
Bookmarks