Hello,
I would like to extract a single number from cells that contain two different numbers seperated by brackets. For example, the value in the cell would be 17.3(20.3). I would like to extract the first number, 17.3, and remove the bracket and second number, 20.3.
I would like a macro that would extract all the first number in the whole column.
If anybody could help me out, I would appreciate it. Thanks!
do you need a macro?
a combination left,find formula could do it
Formula:
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi jl4ec,
Welcome to the forum!!
The following formulas are based on the numbers i.e. 17.3(20.3) being in cell A9 (change to suit):
=ABS(LEFT(A9,SEARCH("(",A9)-1))
=ABS(MID(A9,SEARCH("(",A9),255))
The first formula will return 17.3 and the second 20.3
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks