Hi all,
I am struggling to nest the len, right and left functions.
I paste external data into cell a1 "2 Adults, 4 Children"
In cell b1 I would like to return 4 as a number (that is the number of children)
i.e. remove the word "[space] Children" and remove "2 [space] Adults" keeping the number value 4.
Thanks for any help.
Bookmarks