×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

A1=23,B1="TwentyTree" How??

A1=23,B1="TwentyTree" How??

A1=23,B1="TwentyTree" How??

(OP)
Hi All,

Please, can somebody help with this problem?

Af cell A1=23 and B1=A1, how can I make cell B1 to show "TwentyTree as text string?

Thanks

Zmei

RE: A1=23,B1="TwentyTree" How??

Hello,

THis can be done in Excel, but first you will need to download morefunc.xll (I think it is called).
Visit www.rhdatasolutions.com. You can view the addins and decide whether to download or not. There are may other sites similar to this. I recommend you visit the forum www.mrexcel.com. This has an abundace of information.

Hope this helps.

----------------------------------

maybe only a drafter
but the best user at this company!

RE: A1=23,B1="TwentyTree" How??

Could get very involved and use something like :
=CHOOSE(INT(D7/10),"","twenty","thirty")&CHOOSE(D7-INT(D7/10)*10+1,"","-one","-two","-three")
Assuming number is in cell D7 in this case. Have to have special ones to handle the teens and units though! Add on similar for the hundreds......yuk!

RE: A1=23,B1="TwentyTree" How??

Greetings,

This may be a long shot but it sounds pretty simple-

If you can find a list (or create one depending on how high number you need to reach) of numbers as text strings-

paste the text string numbers in ascending order and then create the numerical equivalent in the column to the left of the text string column however you like etc....

Use the vLookup funtion for cell A1 to return the text string value in B1

This may sound a bit simplistic, however it should work.

Thanks,

Steve

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources