Feb 13 2023 06:42 AM
Feb 13 2023 07:22 AM
It should be sufficient to remove the £, Excel should take care of the rest.
Select the range with currency values.
Make sure that the number format is set to General, Number, Currency or Accounting, NOT to Text.
Press Ctrl+H to activate the Replace dialog.
Enter £ in the 'Find what' box and leave the 'Replace with' box empty.
If necessary, click 'Options >>' and make sure that the check box 'Match entire cell contents' is NOT ticked.
Click 'Replace All'.
Feb 13 2023 07:42 AM
Hans' suggestion is, as always, top class.
I would still use the menu command "Text to Columns" in these cases.