Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex "4F". The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. Ive used HEX2DEC and its variations, but it always takes up two positions in the PC file and is also incorrect in the Mainframe file. How can I get the single hex character to appear? Any help would be appreciated.
October 4, 2010 9:51 PM
November 10, 2010 5:27 PM