Formula to remove fadas when creating student email addresses in excel or Google sheets?

[Eoin McDonnell]

Does anyone know of a formula to remove fadas from a long list of student names when creating student email addresses in excel or Google sheets?

Asking for a gaelscoil,

Best regards 

Eoin

--

Eoin McDonnell

Tech Educator and Schools Account Manager

T: 086 833 2833

E: eoin.mc...@theacademyofcode.com

[Chris Reina]

Hey Eoin,

Find and Replace in Word or any text editor.

Chris

--
--
You received this message because you are subscribed to the Google
Groups "CESI-list" group.
To post to this group, send email to cesi...@googlegroups.com
To unsubscribe from this group, send email to cesi-list+...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cesi-list?hl=en-GB where all messages are archived and are publically available to non members of the list. Messages may also show up in search engines etc.
Visit the web site www.cesi.ie
Attempts to use the list for commercial purposes may result removal from the list.
---
You received this message because you are subscribed to the Google Groups "CESI-list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cesi-list+...@googlegroups.com.
To post to this group, send email to cesi...@googlegroups.com.
Visit this group at https://groups.google.com/group/cesi-list.
For more options, visit https://groups.google.com/d/optout.

[Eoin McDonnell]

Hi Chris,

Yes could do one by one, 

what I am ideally looking for is 

“one formula to rule them all” 

;-)

[Eimear Lyons]

Hi,

Could you use the function "substitute"? 

Eimear

Sent from my HTC

[Val Gavin]

 Hi Eoin

It will be more difficult with the fada, but open your spreadsheet and from the home windows click find and select, then click replace, windows 

Find What 

Replace With

find á 

replace with a

Do this for every letter that has a fada

Val

Val Gavin Computer Services

Unit 12 MGB

Base Centre

Damastown Road

Dublin 15

0872671234

v...@valgavin.biz

----- Original Message -----

From:

"Eoin McDonnell" <eoin.mc...@theacademyofcode.com>

To:

"cesi...@googlegroups.com" <cesi...@googlegroups.com>

Cc:

Sent:

Wed, 27 Feb 2019 12:54:01 +0000

Subject:

{Possible Spam} [CESI List] Formula to remove fadas when creating student email addresses in excel or Google sheets?

Does anyone know of a formula to remove fadas from a long list of student names when creating student email addresses in excel or Google sheets?

Asking for a gaelscoil,

Best regards 

Eoin

--

Eoin McDonnell

Tech Educator and Schools Account Manager

T: 086 833 2833

E: eoin.mc...@theacademyofcode.com

--
--
You received this message because you are subscribed to the Google
Groups "CESI-list" group.
To post to this group, send email to cesi...@googlegroups.com
To unsubscribe from this group, send email to cesi-list+...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cesi-list?hl=en-GB where all messages are archived and are publically available to non members of the list. Messages may also show up in search engines etc.
Visit the web site www.cesi.ie
Attempts to use the list for commercial purposes may result removal from the list.
---
You received this message because you are subscribed to the Google Groups "CESI-list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cesi-list+...@googlegroups.com.
To post to this group, send email to cesi...@googlegroups.com.
Visit this group at https://groups.google.com/group/cesi-list.

For more options, visit https://groups.googlecom/d/optout.

[Chris Reina]

Hi Eoin,

Do you have many spreadsheets?

If you have loads, you could always copy and paste each sheet into one large one. (Which you’d need for import in any case…)

Or - I may have not made myself clear…

All Spreadsheet applications have the ability to “Find and Replace”

You can simply select the letter (or strange character where the fada should be) copy it - then paste into “Find and Replace”

Then replace with the standard letter.

Chris

On 27 Feb 2019, at 14:00, Eoin McDonnell <eoin.mc...@theacademyofcode.com> wrote:

Hi Chris,

Yes could do one by one, 

what I am ideally looking for is 

“one formula to rule them all” 

<DD9FC8F5-0E39-4B0D-BBFB-1034ACB415A8-3259-000001B7CE89F209.gif>

;-)

[Hassan Dabbagh]

find and replace (á) and replace with (a)

find and replace (ó) and replace with (o)

etc 

etc

etc

Ctrl + F OR cmd + f will open the find button.

Hassan Dabbagh

hassan...@gmail.com

On 27 Feb 2019, at 12:54, Eoin McDonnell <eoin.mc...@theacademyofcode.com> wrote:

[Hassan Dabbagh]

What chris said……. nice graphics dude! 

Hassan Dabbagh

hassan...@gmail.com

On 27 Feb 2019, at 14:58, Chris Reina <ch...@teachtech.support> wrote:

Hi Eoin,

Do you have many spreadsheets?

If you have loads, you could always copy and paste each sheet into one large one. (Which you’d need for import in any case…)

Or - I may have not made myself clear…

All Spreadsheet applications have the ability to “Find and Replace”

You can simply select the letter (or strange character where the fada should be) copy it - then paste into “Find and Replace”

Then replace with the standard letter.

<Edit_and_Menubar.png><Find___Replace.png>

<Running_Order_-_Google_Sheets.png><Running_Order_-_Google_Sheets.png>

[Denis Dennehy]

Hi Eoin, my experience would suggest you proceed carefully cos I’ve had difficulty with Gaelgoirí because I was not using the ‘fada’ out of convenience, or simplicity. It can grate and buy trouble, for what it’s worth🥴. - Denis

--
Get the Boomerang Email App on your phone

----------

[G P Ashe]

You will need a macro I think - formula alone would be more cumbersome. Here is a VB script that does it for ALL diacritics. 

You could also add in hyphens depending on how you treat them.

Function StripAccent(thestring As String)
	Dim A As String * 1
	Dim B As String * 1
	Dim i As Integer
	Const AccChars= "áäčďéěíĺľňóôőöŕšťúůűüýřžÁÄČĎÉĚÍĹĽŇÓÔŐÖŔŠŤÚŮŰÜÝŘŽ"
	Const RegChars= "aacdeeillnoooorstuuuuyrzAACDEEILLNOOOORSTUUUUYRZ"
	For i = 1 To Len(AccChars)
	A = Mid(AccChars, i, 1)
	B = Mid(RegChars, i, 1)
	thestring = Replace(thestring, A, B)
	Next
	StripAccent = thestring
	End Function

--

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
G P Ashe

@gpashe

+353 87 234 6850
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[Tim Ó Tuachaigh]

Ahhh you’re on solid ground here Denis.

 

You can’t actually make an email address with fadaí(?) – I’ve tried.

 

Múinteoir Gaelscoile here.

However, you’re right - we do get a bit snotty if you drop them for no reason!

 

Tim.

[Eoin McDonnell]

Thanks everyone for the great options suggested.

Best regards,

Eoin

[Eoghan Keegan]

Hi Eoin, 

The 'Add-on' called PowerTools is great for that kind of thing. You can simplify selected text, including removing fadas, hyphens etc. 

It's free for 30 days, so it's a nice thing to have in August when you might be uploading a lot of names. If you find it's useful, it may be worth the payment.