How this formula work Cell B3 contains the text string you want to remove the leading and trailing spaces from, select a cell which you want to place the result, then use below formula =TRIM(B3) PressEnterkey, the leading and trailing and other extra spaces are removed. If you need, dr...
Any help would be appreciated in leading me in the right direction, thanks in advance. Solved! Go to Solution. Labels: Need Help Message 1 of 33 29,458 Views 0 Reply 1 ACCEPTED SOLUTION greggyb Resident Rockstar In response to GTR 01-08-2016 02:56 PM Didn't have t...
Re: Convert excel formula to SAS Posted 05-12-2016 06:28 PM (2270 views) | In reply to chennupriya The ZW format Writes standard numeric data with leading 0s, and standardizes it to length W, regardless of the length of the input variable. Z3 - states a length of 3 Z4 - ...
Any help would be appreciated in leading me in the right direction, thanks in advance. Solved! Go to Solution. Labels: Need Help Message 1 of 33 29,458 Views 0 Reply 1 ACCEPTED SOLUTION greggyb Resident Rockstar In response to GTR 01-08-2016 02:56 PM Didn't have t...