Hi all, how to get value from this
A1 = "19.92 Down0.76(3.68%) Apr 8, 3:00AM EDT"
I would like to get A2= 0.76 and A3 = 3.68%
What is the formula for this? thanks in advance
Hi all, how to get value from this
A1 = "19.92 Down0.76(3.68%) Apr 8, 3:00AM EDT"
I would like to get A2= 0.76 and A3 = 3.68%
What is the formula for this? thanks in advance
A2:
Formula:
Please Login or Register to view this content.
A3:
Formula:
Please Login or Register to view this content.
Both formulae will return numbers.
If there is no number at this positions it will generate error.
Second formula assuming there is no () brackets before this pair.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks