Re: $$Excel-Macros$$ Combine Name then Time and date stamp for reference number

2015-11-13 Thread Paul Schreiner
n all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Alex K To: MS EXCEL AND VBA MACROS Sent: Thursday, November 12, 2015 11:17 PM Subject: $$Exc

Re: $$Excel-Macros$$ Combine Name then Time and date stamp for reference number

2015-11-12 Thread ashish koul
i tried this =B1&B2&TEXT(B3,"hhmmss") and is working fine. Could you please check it at your end On Fri, Nov 13, 2015 at 9:47 AM, Alex K wrote: > Hello, > >Please see attached file I am trying to combine first name + last name > + timestamp to create a case number. My issue is that when I m

$$Excel-Macros$$ Combine Name then Time and date stamp for reference number

2015-11-12 Thread Alex K
Hello, Please see attached file I am trying to combine first name + last name + timestamp to create a case number. My issue is that when I merge all three together I get a strange time stamp I want HH:MM:SS can anyone help me ? I tried something like this still didn't work =B2&” “&TEXT(B3