Quote:
Originally Posted by andrewsmith
Yep it does Trev, makes sense of the one I got to work earlier
Is there a way to set it up so the ID code isn't present in every cell when its exported?
As the database its for will pick up 100,000 entries instead of the 500 needed
|
I'm a bit rusty with Excel, but you'd probably want to only generate the ID if there was an entry in the name box. Something along the lines of:
=IF(ISBLANK(B1), "", CONCATENATE("text: ", B1))