Thread: [Solved] Convert text to number help
View Single Post
 
Old 01-03-2023, 09:37 AM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
  
Join Date: Mar 2015
Posts: 79
Haha88 is on a distinguished road
Default Convert text to number help
Hi,

I would like some help creating a formula where I can extract the number from the cell and convert it to number form so sum can be added.

I attached the data and the expect result.

Many thanks,
Attached Files
File Type: xlsx Convert text to number form.xlsx (9.3 KB, 9 views)
Reply With Quote