98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Flashfill
Flashfill
Resolved · Medium Priority · Version 365
Wed 16 Oct 2024, 15:38Delegate Victoria said...
Victoria has attended:
Project Introduction course
Excel Intermediate course
Flashfill
I am trying to get flashfill to assist with a common issue we encounter relating to grid co-ordinates. The co-ordinate would be in the form of 2 letters followed by 8 digits. This needs to be converted to 2 columns, each with 6 numbers in (eastings and northings).
As an example:
TQ 2345 3456 (in column A) would become 523450 (in column B) and 234560 (in column C) - ie a 5 in front of and 0 behind the first set of 4 numbers and a 2 in front of and 0 behind the second set.
I got this to work on one attempt but now this fails. Can you help?
I have tried entering multiple rows.
Wed 16 Oct 2024, 16:19Trainer Martin said...
RE: Flashfill
Hi Victoria,
Thankyou for your question to the forum.
Flash Fill does work but you may need use a different method than just simply adding the data by example and pressing enter. Use this other method instead:
1. Type the digits 5xxxx0 for 2 rows (where xxxxx are the digits from column A) and press enter to go to the 3rd row
2. Go the DATA tab and select the 'Flash Fill' icon in the 'Data Tools' section to populate the results
I hope this helps. Please let me know if you get this to work
Kind regards
Martin Sutherland
(IT Trainer)
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Copying the same value, label or formula quickly into a range of selected cells.Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter. |
