Hi have to values in a single cell as two line. I want to use individual values of both line in a formula. I do not want to these values to enter in multiple cells.
For example: i have values 128.53 and 21.2 as two lines in a single cell G5. I want use both values in a simple multiplication formula.
Will it possible? Similarly can use multiple line values?
Last edited by skastroman; 08-29-2017 at 01:48 AM.
Row\Col Number Result 128.53
21.2
B2Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
...Or, with your two-line cell in A1:
=LEFT(A1,SEARCH(CHAR(10),A1)-1)*MID(A1,SEARCH(CHAR(10),A1)+1,255)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If possible can have a formula to multiple each value of A1 to another cell value and give result?
Example: B2 = (128.53*5)+(21.2*5)=748.65
Try as Mr. Glenn Suggested.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks