Hi all,
I have extracted data from a pdf and so all data came in single column like name of the fund and amount, i want to remove the commas ( , ) from the all the numeric values but when i am doing the formula also removing commas from the fund name, any way like formulas to put so the commas get removed from from numeric values only and not from the Fund names (texts)
Example:
Input:
ABC Fund, Limited, LP 425,447,100
XYZ Fund, Limited Partnership, LA 525,447,120
Desired output:
ABC Fund, Limited, LP 425447100
XYZ Fund, Limited Partnership, LA 525447120
