flash fill

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Flash Fill

Flash Fill

resolvedResolved · Low Priority · Version 365

Annie has attended:
Excel Intermediate course

Flash Fill

When using flash fill to separate first name and surname into separate columns - double barrelled surnames such as mine Walwyn-Jones don't fill correctly, it only took over the Jones into the surname column and missed of the Walwyn completely?

RE: Flash Fill

Hi Annie

Thank you for using our forum.

When you used Flash Fill to separate your data, was Walwyn-Jones separated by a space?


Flash Fill does sometimes need a few cells to be completed before it picks up the correct "pattern" in your data


Please let me know if this resolves your query

Kind regards
Wendy Canelas
Microsoft Office Trainer

RE: Flash Fill

Hi Wendy

Thank you - there is a space between first name and surname beginning but no space between the double barrelled name just a hyphen. As follows:

Emily Smith Emily Smith
Annie Walwyn-Jones Annie Jones
Kirsty Monteith Kirsty Monteith
Adam Jones Adam Jones

However, also some surnames are double barrelled but without the hyphen what happens then?

RE: Flash Fill

Hi Annie

Unfortunately if your data isn't following the same structure and format, this could be really difficult for Excel to distinguish between the different bits of text inside the cell


It does work with the double barrelled HYPHENATED surnames but you would need to move them to the second cell and complete two cells instead of one before Flash Fill recognises the pattern


Hope this helps


Kind regards
Wendy Canelas
Microsoft Office Trainer


 

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips


Server loaded in 0.06 secs.