Rayne
asked on
Split in R1C1
This is response to this question:
https://www.experts-exchange.com/questions/28019626/Desired-Format-Pivot.html?anchorAnswerId=38852952#a38852952
There are strings in column A. What formula do I need to insert at column D and B so that column D gets the first value before the “-” and the column E gets the value after the “-”
Row Column Value As Bs
abc-sad p1 25912 abc sad
How to craft the R1C1 here?
Thanks
https://www.experts-exchange.com/questions/28019626/Desired-Format-Pivot.html?anchorAnswerId=38852952#a38852952
There are strings in column A. What formula do I need to insert at column D and B so that column D gets the first value before the “-” and the column E gets the value after the “-”
Row Column Value As Bs
abc-sad p1 25912 abc sad
How to craft the R1C1 here?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A pleasure doing business, Rayne. Do call again.
And thanks for the prompt payment.
And thanks for the prompt payment.
Rayne, you could have just used:
Add a "blank" column after the data to split.
Then Highlight just the column to split.
Then...
Data > text to column > delimited > use "-" as delimiter
Add a "blank" column after the data to split.
Then Highlight just the column to split.
Then...
Data > text to column > delimited > use "-" as delimiter
ASKER
Hello All:)
You are right The_Barman - there are always two sides of the Story
tel2 - You are hilarious, seriously :D
You are right The_Barman - there are always two sides of the Story
tel2 - You are hilarious, seriously :D
Seriously hilarious, Rayne? That's coz I always take humour seriously.
No extra charge for the humour...this time.
Where on earth are you, anyway?
tel2 in NZ
No extra charge for the humour...this time.
Where on earth are you, anyway?
tel2 in NZ
ASKER
Thats GOLD right there, brother :D
in US
in US
ASKER
"No extra charge for the humour...this time" :D
The US? I'm sure I've heard of that place before. Part of the USA isn't it?
One thing I love about the US is, it's built on some strong Christian heritage. NZ is, too. Both places have had it pretty well eroded over the years though, I think. Prayer outlawed in US schools, etc, and plenty of similar things here.
What's do you think is "gold" about NZ?
Just tell me if I'm getting off topic.
One thing I love about the US is, it's built on some strong Christian heritage. NZ is, too. Both places have had it pretty well eroded over the years though, I think. Prayer outlawed in US schools, etc, and plenty of similar things here.
What's do you think is "gold" about NZ?
Just tell me if I'm getting off topic.
ASKER
hehehe- "Prayer outlawed in US schools" !!
I gotta say Kiwi -the cutest bird on mother earth (I am a bird lover) and Chris Cairns, the greatest bowler (allrounder) I have seen from here.
You are fine, no off topic, keep it coming..:)
I gotta say Kiwi -the cutest bird on mother earth (I am a bird lover) and Chris Cairns, the greatest bowler (allrounder) I have seen from here.
You are fine, no off topic, keep it coming..:)
Glad to hear this is somehow still on the topic of Excel, Rayne.
Did you think I was joking about prayer being outlawed in US schools? You know it is, right? I assume it's formal prayer in groups, etc that is illegal.
Did you think I was joking about prayer being outlawed in US schools? You know it is, right? I assume it's formal prayer in groups, etc that is illegal.
ASKER
hehe ...topic of excel.
I knew a bit of it. Constitutional stuff and others. But yeah things change so much down the lane and years. I think the southern part of USA like Texas etc still have stronger heritage feel, to be honest than the northern/north western part. But overall its about the same.
I knew a bit of it. Constitutional stuff and others. But yeah things change so much down the lane and years. I think the southern part of USA like Texas etc still have stronger heritage feel, to be honest than the northern/north western part. But overall its about the same.
OK.
I'm glad to report that our national anthem (which is basically a prayer) has not yet been eroded, though some have tried to replace it. Here's the MP3 and PDF:
http://karakia.co.nz/2011/01/28/free-song-national-anthem/
Feel free to skip the first part of the MP3 which is in Maori - the original language of our native people, who now make up about 10% of the population I think.
I'm glad to report that our national anthem (which is basically a prayer) has not yet been eroded, though some have tried to replace it. Here's the MP3 and PDF:
http://karakia.co.nz/2011/01/28/free-song-national-anthem/
Feel free to skip the first part of the MP3 which is in Maori - the original language of our native people, who now make up about 10% of the population I think.
ASKER
Hello tel2,
I did listened to it today. I really liked it. Its a very mellow, fine tune and feels different. I felt it has a holistic touch to it, feels like it touches every aspect of an entity.
Rayne
I did listened to it today. I really liked it. Its a very mellow, fine tune and feels different. I felt it has a holistic touch to it, feels like it touches every aspect of an entity.
Rayne
ASKER