Remove a specific character or split in to two columns

Jack A

Hi SS team,

I have a data shuttle importing a csv to a sheet. Their is a "Total Invoice Amount" column that is a dollar value but comes in to the sheet with a (') in the front Ex: ('$7,926.41). I am not able to utilize functions like SUMIFS with the data. I am having trouble trying to create a helper column to either "split" that first character from the rest in to two columns or to actually remove it. Any help with this is greatly appreciated!

Corey W.

This should work:

=VALUE(REPLACE([Total Invoice Amount]4, FIND("$", [Total Invoice Amount]4), 1, ""))

Finds the dollar sign, replaces it with nothing, converts the string into a number that can be used for calculations.

Corey W.

This should work:

=VALUE(REPLACE([Total Invoice Amount]4, FIND("$", [Total Invoice Amount]4), 1, ""))

Finds the dollar sign, replaces it with nothing, converts the string into a number that can be used for calculations.