Ok, so say i have a cell with value "3012-3034"
and i want it to put "3012" in its own cell and "3034" into another one beside it.
Is this even possible?
Thanks in advance,
Gavin.
Ok, so say i have a cell with value "3012-3034"
and i want it to put "3012" in its own cell and "3034" into another one beside it.
Is this even possible?
Thanks in advance,
Gavin.
Select the column of data.
Go to Data > Text to Columns (new window will be opened)
Select Delimited option and press Next
Select Others and put - in box, press Next then Finish.
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
wow, excel never ceases to amaze me...
Too bad you cant seem to set two different delimiters for the same data though.
Thanks for your help and for the speedy reply starguy, much appreciated!
Gavin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks