UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Automatically removing characters?    
 
   
sherbs
post Aug 6 2003, 09:50 AM
Post #1

UtterAccess Addict
Posts: 124
From: South Africa
Is there a way I can set a column up so that it automatically deletes the first two characters of any text pasted into each cell?

Thanks for any help.
Go to the top of the page
 
+
Grove
post Aug 6 2003, 11:11 AM
Post #2

UtterAccess Veteran
Posts: 348
From: NW Iowa, USA
You could use the Mid() function. Take a look at the attachment. Is this what you are looking for?
Go to the top of the page
 
+
sherbs
post Aug 6 2003, 01:54 PM
Post #3

UtterAccess Addict
Posts: 124
From: South Africa
It does what I want but it means having to hide and unhide the column containing the origianl text which rather defeats the object. Is there a way I can set up a worksheet so that it happens automatically without having to put the formual in another column?

Thanks
Go to the top of the page
 
+
NateO
post Aug 6 2003, 03:27 PM
Post #4

Remembered
Posts: 5,055
From: Minneapolis, MN, USA
Yes, which column?

It'll be a change event and vb's right() function.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 12:09 AM