separate something in a cell.

[8700Rakf]

So i have a cell with which as the following in it - 100 > m > 10000 - In my case its in cell A21

Is it possible to write a code that seperates the 100 and 1000 to another variable?

 

[Special-K99]

Or use a helper column

in B21
=SUBSTITUTE(A21," > ","")
then use Text To Columns with a separater of m
This assumes that m will always be in the cell between the > signs

One piece of data does not test data make.

 

[Joe4]

On the worksheet, you could use "Text to Columns" using the ">" as the delimiter, and then you would get three variables (100, m, and 10000).
In VBA, you can use the Split function, using the ">" as the split character.
See: https://www.techonthenet.com/excel/formulas/split.php

 

[8700Rakf]

Then you would have to handle it like an array?

 

[Joe4]

Then you would have to handle it like an array?

If you use the VBA Split functionality, yes.
The last example in the link I provided shows an example of that.

It would look something like this:

Sub Test()

Dim LString As String
Dim LArray() As String
Dim ub As Long
Dim firstValue, lastValue

LString = Range("A21")
LArray = Split(LString, ">")

'Find number of values in array
ub = UBound(LArray)

'Get first and last values in the array
firstValue = Trim(LArray(0))
lastValue = Trim(LArray(ub))

MsgBox firstValue
MsgBox lastValue

End Sub

 

[8700Rakf]

Thank you, that explains it!

 

[Joe4]

You are welcome.