Learned people I would like to be able to 'extract' the Total price e.g. 15.50 from each cell in Column B so I can total up our sales in a cell elsewhere - please see attached spreadsheet and many thanks in advance Plant_Preorder_Form_20242024-03-25_08_02_18DEV1.xlsx
How aboutFormula:
Please Login or Register to view this content.
You could use:
=TEXTBEFORE(TEXTAFTER(B2,"Total: ")," GBP")+0
and copy down.
Remember what the dormouse said
Feed your head
Thank you so much for your ultra quick reply; that's perfect!!
Thank you so much !!
=MID(B2,SEARCH("Total: ",B2)+7,SEARCH(" GBP",B2,(SEARCH("Total: ",B2)+7)+1)-1-(SEARCH("Total: ",B2)+7))*1
and copy down the column
SUM() these values
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
xxxxxxxxxx
Last edited by Jacc; 03-25-2024 at 09:31 AM.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks