Excel VBA Using Variables in Left Statement

[Steve001]

Hello Gurus

Lots of posts on here about this sort of thing but cannot get them to work.

Looking at the following statement:

=LEFT(Y2,10)+SUBSTITUTE(RIGHT(Y2,12),":",".",3)

i am trying to replace 'Y2' in both instances with variables not had any luck can somebody please advise

I am using office 363 & office 2021

Regards

Steve

 

[DanteAmor]

You can give a couple of examples of what you have in cell Y2 and what you expect as a result.

 

[Steve001]

Hi Dante,

This post, is what i am trying to do .. pop it at the end of the columns after leaving a bit if a gap

Get Time from Timestamp Data

Hello Everyone, There is loads of time related subjects on here when i searched, but trying to find what i wanted and one that worked was difficult. I have data from a Data logger that timestamps data example as below 12/03/2024 15:49:13:179 to 15/03/2024 07:40:43:179 What i want to do...

www.mrexcel.com

I am trying to populate the cell with that formula, but biased on variables to position it in my sheet using cells.Formula

Regards

Steve

 

[DanteAmor]

The management of variables in the formula is only possible in versions of 365, 2021 onwards

Try:

=LET(a, Y2,LEFT(a,10)+SUBSTITUTE(RIGHT(a,12),":",".",3))

 

[Cubist]

The management of variables in the formula is only possible in versions of 365, 2021 onwards

Try:

=LET(a, Y2,LEFT(a,10)+SUBSTITUTE(RIGHT(a,12),":",".",3))

In the thread title, the OP is asking for VBA.

 

[DanteAmor]

In the thread title, the OP is asking for VBA.

Gud catch

I am trying to populate the cell with that formula, but biased on variables to position it in my sheet using cells.Formula

Try this.
The ini variable with the cell that contains cell Y2.
The fin variable with the cell where you want the formula.

Sub UseVariable()
  Dim ini As String, fin As String
  
  ini = "Y2"
  fin = "AA2"
  Range(fin).Formula = "=LEFT(" & ini & ",10)+SUBSTITUTE(RIGHT(" & ini & ",12),"":"",""."",3)"
End Sub

 

[Steve001]

Hi Dante,

Brilliant thank you

Steve