split cell contents
Hi All,
I have column of cells, each cell has an alpha-numeric content.
I would like to split it up.
for example:
Cell contains: A05B
I would like to take this cell and put the 'A', to '0' and the "5B" into 3 seperate cells.
New cells contents: cell1=A, cell2=0, cell3=5B.
(or split any combination of the above)
Thanks,
Dave
Last edited by DaveRust; 03-04-2010 at 11:51 AM.
Hi,
You can use Data Text to Columns ... from main menu ...
HTH
I tried that... there are no delimiters within the cell... I tried formatting the cell to text still didn't work.Originally Posted by JeanRage
thanks for your help
Jean Rage,
What would be your delimiter or fixed width in this case ?
Dave,
What determines(or split any combination of the above)
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
just meant that I want to split it up in any combo... the first one then the last three, or the first two, then the last two, ect....
Assume
A2 = A05B
B1, C1, D1 are 1, 1, 2
The B2 would be =MID($A$2,1+SUM($B$1:B$1)-B$1,B$1)
Drag right and down (If there is more then A2)
Excellent, thanks rwgrietveld !!
forgot how to mark this thread solved
Go to the original (first) post, advanced and at the top you'll find PREFIX.
Thanks..... doh...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
DaveRust 
Register To Reply
Bookmarks