how to extract initials from first two words in a name (google spreadsheet)

O

omcsarayar

New Member
Joined
Oct 20, 2022
Messages
9
Office Version
  1. 2019
Platform
  1. Windows
Hi everyone,

I have attached a link to a sample file in google spreadsheet which contains Names. I need to extract the initials from only the first two words in the name.

for example:
George William Norris Smith = GW

I have tried several methods and I am not able to get the right formula. Kindly help on this.

docs.google.com

Sample

Sheet1 Name,Initials (Only First Two Word) George William Norris Smith Damian Francis Joan Clifford James Lee Hailey Cleo Virginia Lawson Tiffany Havannah Frederick Kevin Smith
docs.google.com docs.google.com
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
=arrayformula(left(join("",left(split(A2," "),1)),2))
should work.
 
Upvote 0
Solution
Glad we could help. :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Sorting drop-down list data by Day of the week and then time
Replies
5
Views
159
mj_bowen
M
D
  • Question
From a Google form to an automatic total per month
Replies
0
Views
319
Da Webmasta
D
J
  • Question
Google Sheets Accounting Lookup formula help
Replies
0
Views
223
jcoeng
J
A
  • Question
Monthly totals from list with date ranges
Replies
1
Views
306
Bosquedeguate
Bosquedeguate
T
  • Question
Golf Simulator League - Calculating Golf Handicaps for Google Sheets
2
Replies
12
Views
2K
Fluff
Fluff

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top