Question: how to extract values from text in excel?
Answer: Select the cells where you have the text., Go to Data –> Data Tools –> Text to Columns., In the Text to Column Wizard Step 1, select Delimited and press Next., In Step 2, check the Other option and enter @ in the box right to it.