LinkBack URL
About LinkBacks
Hi,
Firstly i have already found solution to concatenate numbers into strings.
example data : J1=1000m,J2=566m,J3=55m
Please Login or Register to view this content.
I would like to isolate the 1000,566 and 55 into a different cell.
Isolate couple of numbers from a string
Hi,
Firstly i have already found solution to concatenate numbers into strings.
example data : J1=1000m,J2=566m,J3=55mPlease Login or Register to view this content.
I would like to isolate the 1000,566 and 55 into a different cell.
Last edited by tanpa_nama; 09-27-2018 at 04:18 AM.
Your example is unclear. Does J1 contain 1000m and J2 contain 566m, etc, or is the entire string in one cell? Do you want the resulting 3 numbers in one cell, or one cell each (3 cells in total).
Sample sheets are often much clearer than words....
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
hi. updated the post. please see attachment.
Try
B6Formula:
Please Login or Register to view this content.
or
B6Formula:Please Login or Register to view this content.
Copy the same in other cells
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)
but it only get 1000 value.
Did you copy paste the same formula in other cells too. I am getting result through post #4 formulas
yes. i put the formula in B6,D6,F6,H6,J6 all return 1000 value. both formula i use.
See the attached file it is working
aaahh.. need to change the COLUMNS function. thank you. that's the differences
or this... a shorter formula:
=IFERROR(MID(SUBSTITUTE(SUBSTITUTE($A3,"=",REPT(" ",100)),"m",REPT(" ",100)),COLUMNS($B:B)*100,100)+0,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks