Split cell value to otheer cells, based on dots

**intercooler** · 10-13-2012, 01:15 PM

Hi, i would deeply appreaciate your help on the following:
I have a column with cell value aaa.bbbb.cccc and somettimes c's are missing and a's and b's are not always 4 characters.
What i would like is to seperate these values in the next columns, using the dot
(If my A1 cell contains aa.bbb.cccc i would like to split it as follows: aa in B1, bbb in C1, cccc in D1 etc.)
I could not use the left/right functions as the number of characters is not static.The good thing is that the delimeter is always a dot.
Thank you in advance

**jeffreybrown** · 10-13-2012, 01:18 PM

Use Text to Columns with the "." as the delimiter

Data >> Data Tools >> Text to Columns

http://office.microsoft.com/en-us/ex...010102340.aspx

**mike7952** · 10-13-2012, 01:38 PM

As Jeff as suggested that will be easy and no macro required. But if you need one then something like below will work.

Please Login or Register  to view this content.

**intercooler** · 10-15-2012, 05:36 PM

Thank you both. I did not realize i could do this with text to colum. Actually i did it but for a single cell. Just did not try it on the entire column

Anyway, thnaks again and i promise to think twice before i post

**jeffreybrown** · 10-15-2012, 05:37 PM

No problem and we are glad to help. Thanks for the feedback

--------------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save