Like A1 references the "16" in "16 candles" in B1
Like A1 references the "16" in "16 candles" in B1
Excel 1.0.1 (16.0.14326.20140) (Android)
Excel 2010 14.04.4760.1000
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Note: you will need examples of all possible scenarios.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Maybe this in A1:
=--LEFT(B1,FIND(" ",B1)-1)
Hope this helps.
Pete
It may be in "A1"
Formula:Please Login or Register to view this content.
By pressing shift+ctrl+enter
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks