Hi Chris (long time no see but I notice you have lots of subjects of interest to me) Thankyou for clarifying the Left with Find. I press F4 three times to lock in the column reference. Text before is easy when available. Flash fill sometimes has to be temporarily segregated from the column to its left to stop it coming up with ridiculous updates to its result.
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.
Hi Chris (long time no see but I notice you have lots of subjects of interest to me) Thankyou for clarifying the Left with Find. I press F4 three times to lock in the column reference. Text before is easy when available. Flash fill sometimes has to be temporarily segregated from the column to its left to stop it coming up with ridiculous updates to its result.
this was so helpful thank you so much. I love the flash fill
You're so welcome!
been searching for this for 2 days. Thanks
Glad I could help
New lesson by an awesome person
Thank you!
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!
This worked. Thanks a lot!
You're welcome!
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.
Thanks Chris , Cool,
Any time! Thanks, R A.
Thank you sir!
You are welcome!
Hi. I saw your explanation of the TEXTBEFORE. you didn't explain what to do in case of the 2nd dash.
Nice, do you have tutorials about power query?
Super❤
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.
❤ Surprised
😭😭😭🤕🤕🤕 thank you.
welcome.