Hello -
I have info in two cells that needs to be concatenated into one cell (Cell
E30) as follows:
(Some 8-digit number)(hyphen)(date in format of yyddmm).xls
An example would be 87654321-052808.xls
The 8-digit number is in cell H16 and the date is in cell H18. The format
for the date cell is set at dd/mm/yyyy.
I've tried putting this into a function, but keep getting errors.
Any suggestions will be immensely appreciated.
--
Sandy
Bookmarks