FileMaker is not a spreadsheet program. Some tasks that are simple for a spreadsheet will not be for a database. The reverse is also true.
you can do a Records>Replace Field Contents and replace the contents of Field B with a calculation (Field A). Just be careful. This cannot be undone.