The conditional formula: =IF(LEN(AD1)=8,"http://3w.deliveryservice1/
D1)=12, HYPERLINK( CONCATENATE(AS1,AD1,AT1)),
The formula works fine. Looking to see if enhancements are possible.
If AD is blank is if possible to make the cell where the formula resides blank?
If AD has a tracking number is it possible to include in the same cell with the URL but NOT part of the URL/Hyperlink?
Thanks in advance