Posted to microsoft.public.excel.misc

pjsmith4321 pjsmith4321 is offline

external usenet poster

Posts: 2

Removing a digit from a column

Thanks. Worked perfectly.

PJS

"FSt1" wrote:

hi
try this
=LEFT(F3,LEN(F3)-1)
adjust cell address to suit. copy down.

regards
FSt1

"pjsmith4321" wrote:

I have a column of data that I need to remove the last digit in each cell.
Is there a formula for doing so, so that I don't have to use find and replace?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Finding Info from Column A and Removing it from Column B	Johnny B[_2_]	Excel Discussion (Misc queries)	2	March 28th 07 12:06 PM
Removing a check digit	cwd58	Excel Discussion (Misc queries)	3	June 22nd 06 06:07 PM
How do I insert the same extra digit to each cell in a column?	GR	Excel Discussion (Misc queries)	7	October 5th 05 07:40 PM
removing digit or calc LEN fields	tri_p	Excel Worksheet Functions	3	October 4th 05 06:02 AM
In Excel, how do I sort a column by the LAST digit of the data?	DougMash	Excel Discussion (Misc queries)	2	May 12th 05 08:54 PM

All times are GMT +1. The time now is 04:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us