Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
In a formula is there a command to send text to the next line?
I know how to do this when typing in excel however is there a formula to do this in the formula line?
So if the formula I currently have is:
=IF(ISBLANK('Copy from PLM'!D1),"",IF('Copy from PLM'!D1="1st","123 Easy St San Diego, CA 99999 888.888.8888 877.888.8888 fax",IF('Copy from PLM'!D1="2nd","789 Easy St San Diego, CA 99999 888.888.8888 877.888.8888 fax")))
If "1st" is entered in 'Copy from PLM'!D1 then result would be:
123 Easy St
San Diego, CA 99999
888.888.8888 877.888.8888 fax
instead of:
123 Easy St San Diego, CA 99999 888.888.8888 877.888.8888 fax
Dustin Shepard
