remove $ and B

[BRRLL99]

Hi 

I would like to remove both $ and B from the given data using multi-field tool

A	B	C
$86.85 B	$7.81 B	$192.59 B
$54.42 B	$4.32 B	$696.51 B
$22.51 B	$5.11 B	$280.16 B
$21.89 B	$3.01 B	$226.39 B

[FilipR · Accepted solution]

See here:

[DataNath · Accepted solution]

Can use the Regex_replace() function to do that like so:

[OllieClarke · Accepted solution]

Hey @BRRLL99 
Try this formula:

TRIM(ReplaceChar([_currentfield_],'$B',''))

Hope that helps,

Ollie