Spreadsheet formulas to get your job done.

Working with spreadsheets? Get rid of boring, repetitive manual tasks - let formulas do them for you.

Get name from email address
john.smith@example.com
John Smith
Reverse first name and last name
John Smith
Smith John
Replace middle name with initial
John Thomas Smith
John T. Smith
Create email address from name and domain
John Smith
example.com
john.smith@example.com
Get name from email address
john.smith@example.com
John Smith
Reverse first name and last name
John Smith
Smith John
Replace middle name with initial
John Thomas Smith
John T. Smith
Create email address from name and domain
John Smith
example.com
john.smith@example.com
Get name from email address
john.smith@example.com
John Smith
Reverse first name and last name
John Smith
Smith John
Replace middle name with initial
John Thomas Smith
John T. Smith
Create email address from name and domain
John Smith
example.com
john.smith@example.com
Get name from email address
john.smith@example.com
John Smith
Reverse first name and last name
John Smith
Smith John
Replace middle name with initial
John Thomas Smith
John T. Smith
Create email address from name and domain
John Smith
example.com
john.smith@example.com
Get year and month from date
2022-06-15
2022-06
Convert month to roman in date
2022-12-31
31 XII 2022
Get quarter and year from date
2022-09-30
Q3 2022
Get age from birth date
1980-06-15
42
Get weekday name from date
2022-06-15
Wednesday
Get year and month from date
2022-06-15
2022-06
Convert month to roman in date
2022-12-31
31 XII 2022
Get quarter and year from date
2022-09-30
Q3 2022
Get age from birth date
1980-06-15
42
Get weekday name from date
2022-06-15
Wednesday
Get year and month from date
2022-06-15
2022-06
Convert month to roman in date
2022-12-31
31 XII 2022
Get quarter and year from date
2022-09-30
Q3 2022
Get age from birth date
1980-06-15
42
Get weekday name from date
2022-06-15
Wednesday
Get year and month from date
2022-06-15
2022-06
Convert month to roman in date
2022-12-31
31 XII 2022
Get quarter and year from date
2022-09-30
Q3 2022
Get age from birth date
1980-06-15
42
Get weekday name from date
2022-06-15
Wednesday
Round number to nearest 1,000
1,734.56
2,000.00
Get number from text
ABC123
123
Remove leading zeros
000012
12
Round price to end with ...99.99
573,45
599,99
Add leading zeros
1
00001
Round number to nearest 1,000
1,734.56
2,000.00
Get number from text
ABC123
123
Remove leading zeros
000012
12
Round price to end with ...99.99
573,45
599,99
Add leading zeros
1
00001
Round number to nearest 1,000
1,734.56
2,000.00
Get number from text
ABC123
123
Remove leading zeros
000012
12
Round price to end with ...99.99
573,45
599,99
Add leading zeros
1
00001
Round number to nearest 1,000
1,734.56
2,000.00
Get number from text
ABC123
123
Remove leading zeros
000012
12
Round price to end with ...99.99
573,45
599,99
Add leading zeros
1
00001
Remove country code from phone number
+1 (212) 555-7777
(212) 555-7777
Format number as a phone number
5353939999
(535) 393-9999
Get country code from phone number
(44) 8888 000 222
44
Extract numbers from phone number
+1 (606) 999-1111
16069991111
Remove country code from phone number
+1 (212) 555-7777
(212) 555-7777
Format number as a phone number
5353939999
(535) 393-9999
Get country code from phone number
(44) 8888 000 222
44
Extract numbers from phone number
+1 (606) 999-1111
16069991111
Remove country code from phone number
+1 (212) 555-7777
(212) 555-7777
Format number as a phone number
5353939999
(535) 393-9999
Get country code from phone number
(44) 8888 000 222
44
Extract numbers from phone number
+1 (606) 999-1111
16069991111
Remove country code from phone number
+1 (212) 555-7777
(212) 555-7777
Format number as a phone number
5353939999
(535) 393-9999
Get country code from phone number
(44) 8888 000 222
44
Extract numbers from phone number
+1 (606) 999-1111
16069991111

Pricing

Monthly subscription

$19/month

  • 600+ ready-to-use formulas
  • 100 formulas / month
  • works with Microsoft Excel and Google Sheets
  • all languages

You can test how it works for free, before buying a subscription.
No credit card required, just create an account.

FAQ

You get an access to the library of ready-to-use spreadsheets formulas that will do repetitive manual tasks for you, automatically.

No. As long as you know how to copy a formula to another cell, so that you can make use of it in more cells :)
(By the way, you can do it in many ways, for example by Copy and Paste or by grabbing a right-bottom corner of the cell)

Yes. If you are an advanced spreadsheets user, then you know that writing complex formulas might be time consuming. In many cases, you need to learn about new functions, watch some tutorials on Youtube etc. before you find solution. With Useful Formulas you can get it in seconds - just like copy and paste.

While it is definitely worth learning (and we encourage you to do so!), you need to be aware that it takes time and patience to see the results. However, we often need a solution here and now - that's when Useful formulas are perfect.

On the other hand, it is also a solution for those who do not use spreadsheets on a daily basis and such competences are not crucial for them (sales, marketing, etc.). With Useful formulas they can achieve similar results in improving the efficiency of their work, without advanced courses.

Yes. Create an account and see how it works for you. No credit card required. However, on free trial you can only get a very limited number of formulas.

No. Useful Formulas will work with every number or date format, as long as spreadsheet recognises them as a number or date. Format used in examples is just one of many options :)