Originally Posted by
AlKey
Actually you can use just one formula to get the account and dollar amount
Copy and paste formula in B1 and pull it to C1
=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),(COLUMNS($A1:A1)-1)*255+1,255))
|
A |
B |
C |
1 |
11112222 $1234.56 Sample, Name Sample Note |
11112222 |
$1234.56 |
oh that's pretty cool, didn't know about that combination
I'd use that one if you need to split everything off, it works every time it finds a space too so it'll separate everything if you copy to F. If there is always a comma after the third criteria....you could triple the formula length to get rid of it!
=IF(RIGHT(TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),(COLUMNS($A1:A1)-1)*255+1,255)),1)=",",LEFT(TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),(COLUMNS($A1:A1)-1)*255+1,255)),LEN(TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),(COLUMNS($A1:A1)-1)*255+1,255)))-1),TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),(COLUMNS($A1:A1)-1)*255+1,255)))
lol
Bookmarks