Extract a portion from string

[irfankundi786]

I have a string like 1234 x 4566 x 34cm x 1245666cm I get this value from excel cell and put it into variable then I want to get the value from 1 to x and then from next x to x and similarly..
I want to this
dim a as integer
dim b as integer
dim cellval as string
cellval = get the cell value
now I want this but get error
a=instr(cellval,'x')-------first x
b=instr(cellval,'x') =---------second x
msgbox Mid(cellval,a,b)-------------------------but get error....

how I can put MID(cellval,'herer instead of 1,2,3 I want to put variable')

[FDibbins]

Hi, welcome to he forum

You need to show us what you expect, not just some code that doesnt work

What should your answer look like?

[irfankundi786]

simply I need only split the string as I mentioned. using MID(string,here I want to put the variable instead of integer....)

[FDibbins]

I ask again, what would your expected answer look like? If I knew what you wanted, I would not have asked

[irfankundi786]

108 9/16 x 59 1/4 x 1 3/4 inches 275.7 x 150.5 x 4.5 cm
8 1/8 x 59 1/4 x 1 3/4 inches 275.7 x 150.5 x 4.5 cm
these are column value exist in single col now I want to convert these value as
108.5625x 59.25 x 1.75 inches 275.7 x 150.5 x 4.5 cm

just conver each fraction into decimal and append in exact that place.whether these is using vba or simple excel formula

[irfankundi786]

Or Simply divide the below cell value into three parts on the basis of x
108 9/16 x 59 1/4 x 1 3/4 inches 275.7 x 150.5 x 4.5 cm
such one col split into three as
col1 col2 col3
108 9/16 59 1/4 1 /3/4
How we can do it but the 108 9/16 x 59 1/4 x 1 3/4 inches 275.7 x 150.5 x 4.5 cm is in variable and then in the variable we should split it.

[nilem]

maybe something like this

Please Login or Register  to view this content.

[irfankundi786]

thx nilem for your reply.
yes its works actually i a whole column which contain such value , i want after doing the above working converting the fraction into decimal then join the string in such manner as 108.5625 x 59.25 x 1.75 inches.........
how i can do this?

[AlKey]

As I understand you only need to convert the first part of the string. Here is a formula solution
Enter in B1 and copy across to cell D1 and then down

Please Login or Register  to view this content.

v	A	B	C	D
1	108 9/16 x 59 1/4 x 1 3/4 inches 275.7 x 150.5 x 4.5 cm	108.5625	59.25	1.75
2	8 1/8 x 59 1/4 x 1 3/4 inches 275.7 x 150.5 x 4.5 cm	8.125	59.25	1.75

[nilem]

or maybe so

Please Login or Register  to view this content.

[FDibbins]

I was going to go the same way AlKey went, but he beat me to it

[irfankundi786]

great its works thx to all expert

[irfankundi786]

can anyone get me an idea about it
x 12.3 x 23.4 x 4.5
in each cell i have x in starting i want to remove the starting x in each row of cell
as 12.3 x 23.4 x 4.5

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	x 12.3 x 23.4 x 4.5	12.3 x 23.4 x 4.5