Results 1 to 3 of 3

Thread: Replace in a formula? {El Resolved-ed}

  1. Sep 29th, 2006, 01:08 PM #1
    Spajeoly
    Spajeoly is offline

    Thread Starter
    Frenzied Member Spajeoly's Avatar
    Join Date
    Mar 2003
    Location
    Utah
    Posts
    1,068

    Replace in a formula? {El Resolved-ed}

    Hey all, I know how to use Replace() in code of course, but is there a formula you could use to do the same thing as: Replace(ActiveCell.Value, Chr(10), "") ?

    I was checking out the =Replace() Formula but it doesn't seem to work the same.

    Thanks.
    Last edited by Spajeoly; Sep 29th, 2006 at 02:15 PM.
    Reply With Quote Reply With Quote
  2. Sep 29th, 2006, 01:14 PM #2
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Replace in a formmula?

    That's because you want to use:

    =SUBSTITUTE($A$1,CHAR(10),"")






    zaza
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes
    Reply With Quote Reply With Quote
  3. Sep 29th, 2006, 02:14 PM #3
    Spajeoly
    Spajeoly is offline

    Thread Starter
    Frenzied Member Spajeoly's Avatar
    Join Date
    Mar 2003
    Location
    Utah
    Posts
    1,068

    Re: Replace in a formmula?

    Just what I needed, thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width