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. 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.
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.
been searching for this for 2 days. Thanks
Glad I could help
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. I saw your explanation of the TEXTBEFORE. you didn't explain what to do in case of the 2nd dash.
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.
This worked. Thanks a lot!
You're welcome!
New lesson by an awesome person
Thank you!
Thanks Chris , Cool,
Any time! Thanks, R A.
Thank you sir!
You are welcome!
Nice, do you have tutorials about power query?
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.
Super❤
😭😭😭🤕🤕🤕 thank you.
welcome.
❤ Surprised