KopRed

Posts: n/a

Thanks! Perfect.

"James" wrote:

You could use the following formula - if the data is in column B enter the
formula in the next column

=LEFT(B5,LEN(B5)-2)

"KopRed" wrote in message
...
How can you remove the last two characters from a range of cells in Excel?

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
What formula is used for subtracting a range of different cells f.	tim	Excel Worksheet Functions	3	April 21st 23 10:07 PM
Formula help for using a range of cells!	Sukismomma	Excel Worksheet Functions	5	January 27th 05 02:34 AM
How can I dynamically eliminate blank cells in a given range in E.	Scott Steele	Excel Worksheet Functions	6	December 17th 04 03:23 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
How do you delete one cell from a range of protected cells	Cgbilliar	Excel Worksheet Functions	2	November 3rd 04 10:42 PM

All times are GMT +1. The time now is 08:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us