LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default altering text to other column

I have a database that includes states and district numbers in separate
fields. I need to take those 2 fields and change them to a third combined
listing.
For Example:

Tennessee 5 and change to TN_05
Arkansas 2 and change to AR_02

I will eventually have over 3000 entries and any help would be greatly
appreciated
 
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
copy without altering the value freebee Excel Discussion (Misc queries) 4 October 31st 08 06:09 AM
Altering text colours using a formula barry24uk Excel Discussion (Misc queries) 1 October 2nd 07 12:48 PM
Please help me with altering text in excel Mark New Users to Excel 5 November 16th 06 04:33 AM
Altering the X-axis Maguire Charts and Charting in Excel 2 May 14th 06 07:45 PM
Formula keeps altering by itself! Julie P. Excel Worksheet Functions 3 February 2nd 05 10:20 AM


All times are GMT +1. The time now is 03:24 PM.

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"