Good day,
Can anyone help me with the following:
I would like to know if you can split 1 single cell into multiple cells in 1 column?
Thank you,
Good day,
Can anyone help me with the following:
I would like to know if you can split 1 single cell into multiple cells in 1 column?
Thank you,
Yes, you can almost certainly do it, but without an example of what you're trying to do or (better still) a sample workbook it's very hard to advise you exactly what to do.
Last edited by Andrew-R; 04-24-2012 at 10:31 AM. Reason: 'Without' without an out
Ηι and welcome to the forum
Yes you can.
Give as an example.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
untitled.JPG
Thanks,
I did give an example, I hope you can see what I inserted
Thanks
hello
maybe you can try ----text-to-column
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Or...
In C9, Put this formula.
=LEFT(B9;FIND(":";B9)-1)
In D9, this.
=TRIM(MID(B9;SEARCH(":";B9)+LEN(":");255))
Change all the semi-colons in my formula, with comma, if you have to do it.
Hope that helps you.
Edit: I just noticed, that you need also this sign( with your first word.
So in my first formula, add this. &":"
=LEFT(B9;FIND(":";B9)-1)&":"
Last edited by Fotis1991; 04-25-2012 at 03:07 AM. Reason: Edit:
Thanks,
Still not working correctly, I must be doing something wrong. It keeps telling me Value or error.
Is there some toolbar I can just open with a split function? haha
Thank you anyway!
Hi
Take a look to the sample.
Thanks!
I wanted to know how you can do that as well, but....
I want to know if you can split a cell in Column B into 2 cells but still remain column B? I don't want to information in two columns, I want to put it in 1 column but in 2 cells in that column.
Am I just a bit difficult now? haha
Thank you
..Do copy & paste, cell C9 & D9, in any cell in Column B, you want(One by One)...
Hi,
Not working. But I will just putting it in by hand.
Thanks
Other than what OTIS 1991 used, wich does not work on all versions of Excel, Excel does not provide this function as far as I know.
On the other hand, Corel Quatro does have this function.
Not saying to change from Excel to Quatro, but the only easy way to do it is to merge the 2 columns as far down as you need and unmerge only those cells you need to split.
That is the easiest way and further more, losing one column does not make you lose any space.
Limitations in rows and columns excel 2010: 1,048,576 rows by 16,384 columns
Limitations in rows and columns excel 2003 & 2007: 65,536 rows by 256 columns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks