This is a great tutorial. I love how in your description you put a link to the time of the video for each method. Great work. I ultimately used Method 4 which worked perfectly, but would love to see the video/ explanation for that. Do you ultimately create a video tutorial for that? If so, can you provide a link?
Hello, I currently have to split names from cells that are presented in this format: STEVENS/JOHNSON/JOHN MARK into 4 separate columns but using formulas instead of text to columns, and they have to be presented as: STEVENS JOHNSON JOHN MARK in the 4 separate columns, would any of these work for that purpose?
Thank you for this great video. I could use your help to split a lengthy line of text (copy a paragraph from an article into a cell. It is difficult to read without scrolling) into multiple lines (rows)
I have about 500 names (First and Last) and their email addresses. They are in a column in a text file, each customer on a separate line. How do I get this column of the 500 names and email addresses into Excel and then separate them so the the first name is in a column, the last name is in a column, and the email address is in a column? I tried copying and pasting all columns to the first name cell, highlighting the cell and then running the separate text into columns wizard, but it didn't work. It wouldn't allow me to choose the destinations for their last name and email addresses. Thanks for your help. You make it look so easy.
Great tutorial, but what I’m facing is kind of impossible to resolve. I received a report from a client I’m working on, the information of several rows are all in one row only !, If I try any of the steps in the video it will remove most of the data. Is it possible to resolve it ?! Please help
How to align multiline text in one cell after a Bullet without moving bullet?. Problem is Bullet also moves as the first letter of text. I want to keep it fixed at a space and rest of multiline text, aligned and move with indent. Bullet should be stationery and text goes indented. Both the Bullet and Text are in same cell.
Ma'am, I want to split "PointA-PointB" this text by "-" & using only excel function, how can I do it? Could you please share the exact function, so that one column will get "PointA" & next column will get "PointB". I don't want to use "Text to column" option. I want to use only formula. How can I do it? could you please share the formula text? Thanks in advance.
Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith Thank you so much!!
Objective: to create a constant, of a date, obtained from a formula If (). I can separate hour/minute/second. But when I delete a column or run a macro the date hh:mm:ss changes. I wonder if there is another way to create unchanged/constant date?
How can i separate "Alex Smith Robert Deniro Al pacino" By name and surname in the same column? I have no Characters, only spaces between name, surname and name again
You can use whatever you want as your delimiter. So for example when using text to columns change the delimiter to other and then type in your word. In power query split using "custom". For the formulas change " " to your word with quotation marks around it.
This is a great tutorial. I love how in your description you put a link to the time of the video for each method. Great work. I ultimately used Method 4 which worked perfectly, but would love to see the video/ explanation for that. Do you ultimately create a video tutorial for that? If so, can you provide a link?
ua-cam.com/video/5l4YA2FEwN4/v-deo.html
You make some difficult things look simple. Thanks a lot for your help.
Thank you Karina, this is a great tutorial for a new guy in excel and everything is explained in detailed.
great method
you 've just acknowledged me that making a new customized function is easy and possible
Your presentation is very clear . Thank you very much . It helps me .
Thank you so much I was looking for Google sheet method. It helped me lot thank you madam.
Thanks video!
rng change to variant can nested used then u can select u wanted in two dlim
Really well explained! thanks a lot :)
This is amazing. I had a simple task but nonetheless very useful! Bookmarking this video
Great job Karina. Thanks for the ispiring
Wow great tips Thank you very much for this video...
This video is
Great!
Awsome!!
And
Making speechless!!!!
Thank you
Thank you so much.
Hello, I currently have to split names from cells that are presented in this format: STEVENS/JOHNSON/JOHN MARK into 4 separate columns but using formulas instead of text to columns, and they have to be presented as: STEVENS JOHNSON JOHN MARK in the 4 separate columns, would any of these work for that purpose?
Life saviour. Really amazing trick. Thanks a lot.
Amazing 👏
Any tutorials on Lambda function?
Control+E! Brilliant - thanks
I just want to say, thank you!!!
Thank you for this great video. I could use your help to split a lengthy line of text (copy a paragraph from an article into a cell. It is difficult to read without scrolling) into multiple lines (rows)
Try "Wrap Text"
Go to "Home" -> "Alignment" -> "Wrap Text" (The button with "ab" and then a curved arrow going to "c" on the next line.
good video, first like for the video ;)
very useful video, Thank You
Excellent...it is timely
Thank you, this is super helpful!!!
I have about 500 names (First and Last) and their email addresses. They are in a column in a text file, each customer on a separate line. How do I get this column of the 500 names and email addresses into Excel and then separate them so the the first name is in a column, the last name is in a column, and the email address is in a column? I tried copying and pasting all columns to the first name cell, highlighting the cell and then running the separate text into columns wizard, but it didn't work. It wouldn't allow me to choose the destinations for their last name and email addresses. Thanks for your help. You make it look so easy.
Thanks Karina. Legend!
Hello,
Do you have the video uploaded explaining the formula? Cheers
thank you! you saved me!
Flash fill method got me subscribed to your channel.
Great tutorial. Thanks for sharing
Helpful. Thanks!
Very good video. Thanks
Truely... detailed work done...
Great tutorial, but what I’m facing is kind of impossible to resolve.
I received a report from a client I’m working on, the information of several rows are all in one row only !,
If I try any of the steps in the video it will remove most of the data.
Is it possible to resolve it ?! Please help
Could you try to Transpose the table and then use Text to Columns
How to align multiline text in one cell after a Bullet without moving bullet?. Problem is Bullet also moves as the first letter of text. I want to keep it fixed at a space and rest of multiline text, aligned and move with indent. Bullet should be stationery and text goes indented. Both the Bullet and Text are in same cell.
Ma'am, I want to split "PointA-PointB" this text by "-" & using only excel function, how can I do it? Could you please share the exact function, so that one column will get "PointA" & next column will get "PointB". I don't want to use "Text to column" option. I want to use only formula. How can I do it? could you please share the formula text? Thanks in advance.
I only want it to separate the text with the first space is there a way to do this ?
Yeah. You're a godsend!
Wonderful!
Thank you very very much
Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith
Thank you so much!!
Use Text to Columns but choose Other for the Delimiter and type in the minus symbol
Objective: to create a constant, of a date, obtained from a formula If (). I can separate hour/minute/second. But when I delete a column or run a macro the date hh:mm:ss changes. I wonder if there is another way to create unchanged/constant date?
Thankyou sooooooooo much!
Thanks very much useful
Thanks Sir.
THANKS!!!
I can't seem to delimit text more than 5 columns.. it just deletes the rest in "text to columns" is this a glitch?
I'm stuck with some data. Can you help me please?
Very clever
Thank you ❤️
Thank you
Great Mam!
Superb 😍😍
How can i separate "Alex Smith Robert Deniro Al pacino" By name and surname in the same column? I have no Characters, only spaces between name, surname and name again
have you done that other video on the formula
Yes I made the formula video ua-cam.com/video/5l4YA2FEwN4/v-deo.html
Very wonderful
How do I split the content after specific words?
You can use whatever you want as your delimiter. So for example when using text to columns change the delimiter to other and then type in your word. In power query split using "custom". For the formulas change " " to your word with quotation marks around it.
You should join the Marvel Universe because you a superhero!
Thanks ..
The best
I don’t have “flash fill”
Great instruction but am I the only person that has like info in a single cell that I need to extract into separate cells?
How to split wrapped text.
Keyboard shortcut: Alt + Enter
How to Split text in Google Sheets:
=Split(Then put in the damn text)
Excel is such trash when compared to its Google counterpart.
Garbage program.
Thank you very very much