MaximumGravity
New Member
- Joined
- Apr 16, 2002
- Messages
- 29
Hi all,
I am trying to write a function (maybe I need a macro or VBA code) that will look at the value of a cell, if it is not blank, append the cell to read "MSRP: $" + the value of the cell - hence
But this isn't working. This is going to be used to mail merge into word. And if there is no MSRP for a given field, we don't want the words MSRP to appear with a blank afterwards.
For any MS Word gurus, if ther eis an easier way to do this from within word, let me know.
Thanks in advance
Russell
PS HTML tags getting interpreted by "<>" in title
This message was edited by MaximumGravity on 2002-08-29 12:21
I am trying to write a function (maybe I need a macro or VBA code) that will look at the value of a cell, if it is not blank, append the cell to read "MSRP: $" + the value of the cell - hence
Code:
=IF(A2<>"","MSRP: $ " + A2 )
For any MS Word gurus, if ther eis an easier way to do this from within word, let me know.
Thanks in advance
Russell
PS HTML tags getting interpreted by "<>" in title
This message was edited by MaximumGravity on 2002-08-29 12:21