-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Separating data into separate cells
- Thread starter Brew
- Start date
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
Aladin,
Thanks for letting me know that was intentional. It took some experimenting, but now I see your point. Brew - Aladin's is more robust. By taking out the "+1" and adjusting the reference inside of Column() it makes the formula susceptible to error if one inserts a column between EV and EW or if one selects the cells and drags them rightwards. Aladin's formula does not suffer the same weakness.
Thanks for letting me know that was intentional. It took some experimenting, but now I see your point. Brew - Aladin's is more robust. By taking out the "+1" and adjusting the reference inside of Column() it makes the formula susceptible to error if one inserts a column between EV and EW or if one selects the cells and drags them rightwards. Aladin's formula does not suffer the same weakness.
Upvote
0
Excel Facts
Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
