Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default Concatenate and Multiply

Hi,

Please ignore my previous post. This is the correct one.

A B C D
Island 2 3 4

Is it possible to first multiply digits in cell B1,C1 and D1 and then
concatenate text in cell A1. Also I want to apply formula in A1. I want to
see something like this in cell A1:

Island 24
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Concatenate and Multiply

see your other post

--
Biff
Microsoft Excel MVP


"tipoo" wrote in message
...
Hi,

Please ignore my previous post. This is the correct one.

A B C D
Island 2 3 4

Is it possible to first multiply digits in cell B1,C1 and D1 and then
concatenate text in cell A1. Also I want to apply formula in A1. I want to
see something like this in cell A1:

Island 24



Reply
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
concatenate and multiply problem tipoo Excel Worksheet Functions 7 August 19th 09 06:33 AM
multiply jackievar Excel Discussion (Misc queries) 7 June 5th 07 05:19 PM
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% George A. Yorks Excel Discussion (Misc queries) 10 October 25th 06 09:45 PM
multiply Leonard Excel Worksheet Functions 1 October 19th 05 12:09 AM
I know how to concatenate ,can one de-concatenate to split date? QUICK BOOKS PROBLEM- New Users to Excel 1 July 26th 05 05:07 PM


All times are GMT +1. The time now is 07:19 AM.

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

About Us

"It's about Microsoft Excel"