LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Stinky
 
Posts: n/a
Default auto add "1" to end of value

i have 2 cells in my worksheet that i want a "1" to be added at the end of
whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to see "los angeles1" in the
cell a1


any help would be 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
Auto fill option box disappeared sbrimley Excel Worksheet Functions 5 February 4th 05 03:21 AM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM
auto filter question Juco Excel Worksheet Functions 0 November 29th 04 02:48 PM
auto filter question Juco Excel Worksheet Functions 1 November 28th 04 02:51 PM
Why can't my macro use Auto Filter when I told the Sheet Protecti. KC Rippstein Excel Worksheet Functions 1 October 28th 04 06:13 PM


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