Call data from one cell into two different cells
I have a cell with two numbers in it, ie: "5.27 (-2.5 %)" which is referenced from another sheet (=LTC!A13). I would like to call those two numbers into two separate cells. Keeping in mind that both numbers will change daily (by refreshing a data import from the web) and therefore you never know exactly how many characters there will be in total.
I have uploaded an example. Any help would be greatly appreciated.
D1:
=TRIM(MID(SUBSTITUTE(C1,"(",REPT(" ",100)),1,100))*1
E1:
=TRIM(SUBSTITUTE(MID(SUBSTITUTE(C1,"(",REPT(" ",100)),100,100),"%)",""))/100
and copy down
Format as needed
Last edited by daffodil11; 01-26-2015 at 06:40 PM. Reason: I lolled at DogeCoin
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hi, welcome to teh forum
Try these...
=--LEFT(C1,FIND("(",C1,1)-1)
=--SUBSTITUTE(MID(C1,FIND("(",C1,1)+1,99),")","")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi and welcome to the forum
One way
Formula:
Please Login or Register to view this content.
&
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You guys are Rock Stars! Thank you so much, it's truly appreciated!
Definitely will recommend this site to others.
Yet another way:
Formula:Please Login or Register to view this content.
and
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 01-26-2015 at 07:20 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Sweet! Glad we could help out. We're all going to be famous.
Oh oh, our covers are blown
We had covers??
Some of us did
Lucky covers
hi guys could yo guys help me out in my problems.. sorry to use this tread as my link, but i can see all of you are expert here..
http://www.excelforum.com/excel-form...to-offset.html
shuriyan0924, Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
shuriyan0924, Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
ohh i am so sorry, i didnt know
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks