LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default Mix Titles with Cell Links and Text

I would like to make a chart title have a mix of letters and a cell reference
formula similar to what I do in other cells. For example:

="text" & (left(A1,4))

I would hope this is possible but it keeps giving me an error. I have used
just the ="text" & A1 and it works but when I add the formula, it says no.

Any ideas?

Jeff
 
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
Can't see all the text in a cell when using file links Mark Excel Worksheet Functions 4 June 9th 06 04:19 PM
linking a cell containing text to another cell containing text / data gin2000 Excel Discussion (Misc queries) 5 May 19th 06 09:08 PM
How to execute Macros through Text Links? Sheikh Saadi Excel Discussion (Misc queries) 0 January 17th 06 07:02 PM
'CHECK IF A CELL IN EXCEL HAS ANY TEXT IN IT' Martin in Dublin Excel Worksheet Functions 3 September 16th 05 06:30 PM
External links contain too much text i983corbett Excel Discussion (Misc queries) 0 July 27th 05 11:27 PM


All times are GMT +1. The time now is 03:41 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"