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
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
What you've provided doesn't describe the logic.
Evidently, you want the Q3 figure and Q4 figure for each segment,but is the
column intended to shift for each subsequent segment?
Will the original data set be sorted by segment?
If so, it would be fairly easy to generate the code.
Paul
*Dear All,*
*Pls help...*
*need vba code for specified format...*
*Thanks & RegardsRenukaChari. Kasee*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM R
https://blog.seamonkey-project.org/2015/11/10/seamonkey-2-39-additional-release-notes/#Bugfixes
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) U
https://blog.seamonkey-project.org/2015/11/10/seamonkey-2-39-additional-release-notes/#Bugfixes
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) U
Hi Partner,
Hope you are doing great….
Please send resume to ma...@genuineitllc.com
*Oracle SCM/WMS Consultant---Need 10+ years only*
*Olmsted Falls, OH 44138*
*3 Months with a possibility for extensions*
**
*Oracle SCM/WMS Consultant*
On behalf of our client, We are is searching for a O
Bvhcgh you are yycyucbdb
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Hel
Bvhcgh you are yycyucbd
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help