Forum Discussion
Find and replace?
Hi. I am a complete newbie to this forum and almost as green with excel. I am trying to resolve this issue in an excel import. 7049326328 L (Cell), 8286523017 L (Home), Y (Work), 7049326328 L (O...
Hello Lawrence,
Based on your description I created a video of a non-code solution to your problem using flash fill and attached it below.
If your data is exported as text or a csv file, there is another alternative solution if this does not work for you.
I made some assumptions because you only provided 1 line (row) of data. So I created some additional rows. Take a look and let me know if this helps. I am using Excel 2016 version 1710. I always recommend providing a few rows of sample data so it is easier to test a solution.