Go Back   Technibble Forums > Technical Discussions > Software Applications

  Technibble Sponsor

Reply
 
Thread Tools Display Modes
  #11  
Old 05-01-2012, 08:07 PM
KompuKare's Avatar
KompuKare KompuKare is offline
 
Join Date: Jan 2010
Location: UK
Posts: 463
KompuKare is on a distinguished road
Default

Quote:
Originally Posted by techyguy717 View Post
Thank you, altrenda and everyone else. This saved a lot of time.

I was copying the formula, but was not pasting the formula correctly.
I merely pasted.

After copying the formula I need to:

- Paste Special
- Paste as Formula
No you don't: you fill down CRTL-D (or right, CTRL-R). Alternatively you could copy everything to clipboard, paste into Word, get it to toggle case (Word calls it TitleCase) and paste special the values back in. You'd lose any formulas though. If all the offending UPPERCASE stuff is confined to whole rows or columns you can just copy those though.

If doing this a lot, VBA is the way to go though.
Reply With Quote
  #12  
Old 05-01-2012, 09:16 PM
altrenda altrenda is offline
 
Join Date: Nov 2011
Location: So California
Posts: 1,658
altrenda is a jewel in the roughaltrenda is a jewel in the roughaltrenda is a jewel in the rough
Default

I am not a VBA guy, but how would you do it that is easier than
Enter the formula in the first cell
Select the cells in the column you want to change
Click Home Fill Down on the ribbon (assuming excel 2010)
__________________
When you have eliminated the impossible, whatever remains, however improbable, must be the truth.
Sherlock Holmes
Reply With Quote
  #13  
Old 05-14-2012, 02:21 PM
techyguy717 techyguy717 is offline
 
Join Date: Nov 2011
Posts: 205
techyguy717 is on a distinguished road
Default Correct Name Order. First, MI, Last.

Thank You,

I haven't been able to correctly line up the names though.

"Child, A, Julia" would become "A, Julia Child".
But I need it to be "Julia, A, Child"

Using this formula.
=RIGHT(A3,LEN(A3)-FIND(" ",A3,1))&" "&LEFT(A3,FIND(" ",A3,1))

I'm not sure how to correct this.
Reply With Quote
  #14  
Old 05-14-2012, 02:44 PM
coreyspeed coreyspeed is offline
 
Join Date: Mar 2010
Location: Hertfordshire, UK
Posts: 245
coreyspeed is an unknown quantity at this point
Default

Fomula would be

=LEFT(A3,FIND(" ",A3,1))&" "&RIGHT(A3,LEN(A3)-FIND(" ",A3,1))
Reply With Quote
  #15  
Old 05-14-2012, 03:24 PM
techyguy717 techyguy717 is offline
 
Join Date: Nov 2011
Posts: 205
techyguy717 is on a distinguished road
Default

coreyspeed, I can't get this formula to work.
=LEFT(A3,FIND(" ",A3,1))&" "&RIGHT(A3,LEN(A3)-FIND(" ",A3,1))

I still get this value: Child, A, Julia

When I switch the LEFT and RIGHT. I get this: julia child, A,

I'm trying to get Julia, A, Child.

I'm hoping to use this formula for a few hundred names.
Reply With Quote
  #16  
Old 05-14-2012, 04:16 PM
KompuKare's Avatar
KompuKare KompuKare is offline
 
Join Date: Jan 2010
Location: UK
Posts: 463
KompuKare is on a distinguished road
Default

This is pretty basic stuff, but anyway here goes:

=RIGHT(A3,LEN(A3)-FIND(",",A3,(FIND(",",A3))+1)-1)&", " & MID(A3,FIND(",",A3)+2,FIND(",",A3,FIND(",",A3,1))-5)&"," &LEFT(A3,FIND(" ",A3,1)-2)

That should do it.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:23 PM.


Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Technibble.com is based out of MELBOURNE, AUSTRALIA.