This was Great!! I had to use two formulas the FLASHFILL and I used TEXTAFTER because I had to separate street number and street name on a file that was sent to me with that info in one cell but teh CSV template for uploading to a specific program required the number and name to be in two columns. The list has over 2000 addresses so I needed a way to fix this easily. So Thank you for this very helpful tip!
Hi Chris uncle I need your help. For the correct of email script. When I write Hi , Then "Hi Chris," and and other one not have name in email loo like space "Hi ," Please guide me for this.
Hi Chris. Nice video. I watched your video and did a quick check on the formula only to find that TEXTSPLIT even works better than the LEFT (FIND) function.
Great video as always. Though I have 365 I often find myself doing things in the old-school way, seems muscle memory takes over then find myself redoing the formula using the newer functions available. I would also often use Power Query to prepare data for a report - that way I can do whatever is required for the report and leave the original data unchanged the choice of method depending on the task requirements.
