Hey guys,
Having a bit of a problem....I've got a long list of emails, and I was wondering how I might turn the list into a functional document that I could use for various tasks I've got.
Right now, It looks like this: Screen shot 2011-12-13 at 4.00.31 PM.jpg
And I'd like to get it to this. Screen shot 2011-12-13 at 4.03.05 PM.jpg
I already used the text to column feature, and my attempts to transpose it have been futile...any help would be great.
Thanks!
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Take a moment to read the forum rules/suggestions.
You want a macro to do this, or just formulas reflecting from your original sheet?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
I don't know what that means hah...but I've attached a copy of the original email list, in the hopes that someone might take a look at it and help me out! thanks!
Reformatted for you.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
to do it yourself
copy it
open word
paste special unformatted text into word
now find >,
replace with >^p
replace all
then repeat find ,just hit space bar to put a single space in the find box
replace with ^t
select all copy/paste back into excel
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Awesome guys. Thanks so much for the input and help!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks