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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!