LinkBack URL
About LinkBacks
I have one last problem and then I can finish my project. Can anyone tell me how to do this:
Really Cool Widget in Column A to really-cool-widget in Column D
Thanks!
DukeURL
Really Cool Widget in Column A to really-cool-widget in Column C
I have one last problem and then I can finish my project. Can anyone tell me how to do this:
Really Cool Widget in Column A to really-cool-widget in Column D
Thanks!
DukeURL
Last edited by DukeURL; 12-16-2013 at 06:42 PM. Reason: wrong column
=subtitute(a1," ","-")
Using the example from your previous post, you could use:
=SUBSTITUTE(B1,"{A}",SUBSTITUTE(A1," ","-"))
and save yourself the extra steps.
Last edited by daffodil11; 12-16-2013 at 06:32 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
yeah, in hindsight I should have posted my two problems in the same post...sorry. This is not working: =subtitute(a1," ","-") I get a #NAME error...any ideas why?
daffodil11, darn, I tried your condensed code and the hyphenated code actually needs to go in a separate column, column d. I hope this makes sense
DukeURL
maybe try this...
=LOWER(SUBSTITUTE(A1," ","-"))
Put that in D1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yeah, that works.
In D using your previous example =SUBSTITUTE(B1,"{A}",SUBSTITUTE(A1," ","-"))
The functions breaks down like this:
SUBSTITUTE(what, "replace what", "with what")
So, SUBSTITUTE ("BO123BBY","123","") = "BOBBY" because we replaced 123 with nothing
If A1 = Frodo Baggins, and B1 = Bilbo, then C1 =SUBSTITUTE(A1,"Frodo ",B1) = Bilbo Baggins
Or do whatever FabulousDibbens says. That guy's a level 18 sorcerer or something.
Daffodil and FDibbins, it worked perfectly! Thank you both very much for your help, I can complete my new project now!!!
DukeURL
Sweet. Glad we could help out, always appreciate the feedback.
LOL hardly, daffodil, but thanks for the kind words, and I have seen some really great stuff from you as wellOr do whatever FabulousDibbens says. That guy's a level 18 sorcerer or something.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks