All target cells are in column A, starting with A1
All target cells have the following format
name (number) - Level: number
The name has alpha and special characters and it can have a space or 2 spaces.
The first number (The I.D. No.) is always inside parenthesis () and can be 5, 6 or 7 digits there are no spaces inside the parenthesis only numbers.
The 2nd Number is always at the end of the line after the word "Level: " There is always a space after the : and before the number. The number can be 1, 2, 3, or 4 digits.
Examples:
Winston (7000) - Level: 1134
~Jerry The Rat~ (125007) - Level: 23
@Yurt Earth@ (2245700) - Level: 345
I want column B to be the Level number and only the number
and column C to be the I.D. No. and I would like the output to be in this format [diamond=xxxxxxx]. With the square brackets and xxxxxx = whatever the I.D. number is
So for my examples I would want the following outputs:
"Column A"
Winston (7000) - Level: 1134
~Jerry The Rat~ (125007) - Level: 23
@Yurt Earth@ (2245700) - Level: 345
"Column B"
1134
23
345
"Column C"
[diamond=7000]
[diamond=125007]
[diamond=2245700]
I only need the formula for B1 and C1 then I know how to pull the formula down.
B1
=RIGHT(A1,FIND(" ",A1)+1)
I tried that and this
=RIGHT(A1,FIND(" ",A1)-1)
and this
=RIGHT(A1,FIND(" ",A1))
they all work for the B1 ok but then when pulled down B2, B3, B4, B5 they go all over the place .
17
0) - Level: 20
vel: 23
l: 25
Level: 28