+ Reply to Thread
Results 1 to 6 of 6

Text change to act as a formula

  1. #1
    Registered User
    Join Date
    01-27-2020
    Location
    England
    MS-Off Ver
    Microsoft 365 business
    Posts
    2

    Text change to act as a formula

    Hi,
    Appologies if this has been answered before, but I couldn't seem to find it in a search.
    I pull data from a software package in to excel which as part of product order lines gives me dimensions as 'yyy' x 'zzz'. I can change the 'x' symbol to a * for the formula to work out the area, but I'm unsure how to add an '=' to the front of the text line to make it a working formula. I have tried using the formula ="=" & I2 but it shows it as a normal text string rather than it calculating the formula. I am sure it is something really simple that I've overlooked, but it's driving me crazy having to click each cell (there are usually 80+) to enter the = sign to the beginning of the entry.

    Many thanks in advance

    Mike
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Text change to act as a formula

    Welcome to the forum.

    This should do what you want:

    =LEFT(H2,FIND("x",H2)-2)*MID(H2,FIND("x",H2)+2,99)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: Text change to act as a formula

    HI Mike,

    Check this out!!!


    Formula: copy to clipboard
    Please Login or Register  to view this content.
    *If you wish you click on *,a way to say ThankYou

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Text change to act as a formula

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    01-27-2020
    Location
    England
    MS-Off Ver
    Microsoft 365 business
    Posts
    2

    Re: Text change to act as a formula

    Thankyou both for your help - slightly more technical than I was expecting, but an easy copy & paste :-)

  6. #6
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: Text change to act as a formula

    Mention not!!

    Mike what do you mean by technical here...Hehe if the work can be done by needle then why you need the sward


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    An update increase the value of 4 if your data digits increases in your data set.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change text in formula in sequence
    By bcas77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2013, 06:23 PM
  2. How do I change a formula to text?
    By multimediocrity in forum Excel General
    Replies: 4
    Last Post: 08-22-2009, 06:47 PM
  3. [SOLVED] Change number to text formula
    By Domenic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 09:05 PM
  4. [SOLVED] Change number to text formula
    By Domenic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 07:05 PM
  5. Change number to text formula
    By Fesk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. Change number to text formula
    By Domenic in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 AM
  7. Change number to text formula
    By Fesk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] Change number to text formula
    By Fesk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1