There's formulas, but with that setup you might be better looking at Data -- Text to Columns. With space as delimiter.
Rgds,
Andy
Rgds,
Andy
Splitting values out into separate columns in MS Excel XP
I'm using Excel under Office XP in Windows XP and I'd like to know if there's a formula for dividing a cell that has three different values in it, into three separate columns?
It looks like this:
1 3% xyz
I'd like each value to be in a separate column.
Please help.
Kind regards
Hotelguru
It looks like this:
1 3% xyz
I'd like each value to be in a separate column.
Please help.
Kind regards
Hotelguru
- Status
- Not open for further replies.
1 - 2 of 7 Posts
Hi maxflia10!
>> I know Andy doesn't like addins
Probably I've not expressed my views on this effectively, since I'm currently running ATP (obviously) and John W's Enhanced Data Form and Chip's Symbolizer and Ron's GoogleSearch.
Laurent is a very smart guy, way above my level. Notwithstanding, I just think it's easy to get bogged down with add-ins if you're not careful.
Best rgds,
Andy
>> I know Andy doesn't like addins
Probably I've not expressed my views on this effectively, since I'm currently running ATP (obviously) and John W's Enhanced Data Form and Chip's Symbolizer and Ron's GoogleSearch.
Laurent is a very smart guy, way above my level. Notwithstanding, I just think it's easy to get bogged down with add-ins if you're not careful.
Best rgds,
Andy
1 - 2 of 7 Posts
- Status
- Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
