delete text and move

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have this text in cell A
AMERICA'S CHOICE 400 ANYTIME $39.99 2Y 0204 --- 56290[ $39.99]

I need to only have the number in front of the Y in cell a1 and whatever is in the brackets in cell a
 
I'm pretty horrible with these text parsing formulas, but here goes:

To get the 2:
=MID(A3,FIND("Y ",A3,FIND(" $",A3,1))-1,1)

to get the $39.99
=MID(A3,FIND("[ ",A3,FIND("---",A3,1))+2, FIND("] ",A3,FIND("---",A3,1)) -
FIND("[ ",A3,FIND(" $",A3,1))-2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel saves as text not as a number 3
extract text 3
Add to a "number as text" 10
Macro that will insert a simple text string in top cell of text file 1
Excel VBA help: Text file formatting 19
Convert string to date? 5
For Eachcell in Range tranpose comma seperated values to a list in D 4
Permutations andText to column problem 6

Back
Top