Get the string after the last character in excel-CodePudding

I have the following string in excel cell

"myshop.com" "great"#12#20 Feb 2022

How I can get the string after the last Hash

Output

20 Feb 2022

CodePudding user response：

Edit

To get the string after the last character Hash in excel, you may try anyone of the following solutions,

Solution as suggested by

CodePudding user response：

Another option,

In B1, enter formula :

=TRIM(RIGHT(SUBSTITUTE(A1,"#",REPT(" ",99)),99))

and format the result to your desired Date format