LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BG BG is offline
external usenet poster
 
Posts: 31
Default How to combine text and numbers in exel

Can anyone tell me how to combine text and numbers in the same cell so that
only the number is a value e.g. Fuel at 17 ltrs/hr This would be entered into
one cell but could be used as part of a formula where only the number 17 is
used?
--
BG
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using If to combine answers including text and numbers Tablespider Excel Worksheet Functions 3 September 27th 08 12:16 AM
exel formula for numbers to text Arun Excel Worksheet Functions 2 September 15th 08 06:33 PM
How do I combine Exel workbooks? Kman Excel Worksheet Functions 2 May 5th 08 09:26 PM
formula for automatic up on numbers in cell in exel Not a wiz Excel Worksheet Functions 1 June 12th 07 12:08 AM
Combine many exel files to one MichalH Excel Worksheet Functions 1 March 27th 06 05:52 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"