» Extract the first word in a cell in Microsoft Excel
CATEGORY - Excel Text , Excel Formula
VERSION - All Microsoft Excel Versions
Enter the following text in cell A1: Are you going to Disneyland?
Use the following function:
=IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))
The result: Are
Book Store:
Recommended Books:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Investing in Real Estate, Fourth Edition
- Finance and Accounting for Nonfinancial Managers
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Mastering Excel 2000 (for beginner)
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
I can use the formula :-
=IF(ISERR(FIND(",",A1)),A1,LEFT(A1,FIND(",",A1)-1))
,in a cell but need to write a function in the VB editor to do the same thing!
Does anyone have any ideas?
Regards