LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Andreas
 
Posts: n/a
Default Adding text in formulas

Is there anyway to write a forumla that "adds" text instead of numbers?
ex: If cell 1A contains the text "ABC" and cell 1B contains the text "DEF".
can i add the two text strings into cell 1C so that it appears as "ABCDEF" ?

I'm making a database over a new filenameing structure where the file name
is composed of different abreviations. ex 480AAC01 = State no 4, Town 80,
type of map A, grid AA, sheet 1. sitting and typing this i very tedious but
if i had a forumula this could be done in an instant.

any takers? any suggestions? Please help!

Cheers!
 
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
adding duplicate text to multiple cells beardic Excel Discussion (Misc queries) 4 May 18th 05 09:44 PM
adding cells that contain formulas that have returned error messag Daniel R Excel Worksheet Functions 3 February 21st 05 07:14 PM
Adding cells, using text as number Pgsmom Excel Discussion (Misc queries) 4 January 10th 05 07:21 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Adding a text label to a line. Neil Charts and Charting in Excel 1 December 4th 04 08:41 PM


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