Hi,
I am trying to find and replace data in a cell but its not being recognised.
The data has been exported from our MIS system, it exports with a carriage return in it. I need to remove the carriage return and then the staff initials at the end of the text string.
I've tried removing the staff initials with the carriage return (G9) and not removing the carriage return (F9), but neither methods allow the data to be recognised in find and replace. The data I want to remove is ' RW' with a space before it because of the carriage return or just 'RW'.
I've used =F9=" RW" function in cell C3 to check the data in cell F9 or G9, but get FALSE returned.
I've added =LEN in cell D3 to check the number of characters in cell F9 or G9, to see if there are any hidden characters. The number is correct.
I've tried copying and pasting the contents of cell F9 or G9 into the find and replace function. Still not recognised.
I've added RW to cell G12 on its own. Still not recognised.
The sheet isn't protected. I've tried saving it as 2007. Totally stumped as to why I cant find and replace. Any ideas gratefully received.
Thank you.
I am trying to find and replace data in a cell but its not being recognised.
The data has been exported from our MIS system, it exports with a carriage return in it. I need to remove the carriage return and then the staff initials at the end of the text string.
I've tried removing the staff initials with the carriage return (G9) and not removing the carriage return (F9), but neither methods allow the data to be recognised in find and replace. The data I want to remove is ' RW' with a space before it because of the carriage return or just 'RW'.
I've used =F9=" RW" function in cell C3 to check the data in cell F9 or G9, but get FALSE returned.
I've added =LEN in cell D3 to check the number of characters in cell F9 or G9, to see if there are any hidden characters. The number is correct.
I've tried copying and pasting the contents of cell F9 or G9 into the find and replace function. Still not recognised.
I've added RW to cell G12 on its own. Still not recognised.
The sheet isn't protected. I've tried saving it as 2007. Totally stumped as to why I cant find and replace. Any ideas gratefully received.
Thank you.