LinkBack URL
About LinkBacks
Hi there.
I have a cell that has the following in it.
"1-5 pounds: $4.39"
How do I reference in another part of the spreadsheet ONLY the 4.39 part of what is in that cell?
Hi there.
I have a cell that has the following in it.
"1-5 pounds: $4.39"
How do I reference in another part of the spreadsheet ONLY the 4.39 part of what is in that cell?
hi snuffnchess. you probably need to give a few more samples in order to see a pattern. right now, what i see is that you want the numbers after the dollar sign:
=--MID(A1,FIND("$",A1)+1,100)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
I tried doing what you suggested and received an error.
Uploading a sample sheet of what I am trying to.
Raw Data Entry tab will do some calculations there..... Sheet 2 want to look nice and pretty like what you see here.Book2.xlsx
snuffnchess, Good evening.
Try this one:
Suppose your data is at A1
=RIGHT(A1,LEN(A1)-FIND("$",A1,1))*1
Is this what you want?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Perfect!
Thank you Mazzaropi!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks