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: 2
Default Globally deleting part of the information in a cell

I have many rows of data. In several cells, the end of the data in the cell
ends with a period, some numbers and an x. So the information to be deleted
would like something like .035x where 035 could be any number. Since there
is other data in any given cell, I would like to delete everything in a cell
from the period and anything following it.
Is there a way to do that?
 
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
Deleting part of the infomation in a cell Office Lapis Excel Discussion (Misc queries) 4 August 2nd 07 08:14 PM
deleting information from a cell Katti1215 Excel Discussion (Misc queries) 1 January 25th 07 08:46 PM
moving part of information from one cell to another... auntwanette Excel Worksheet Functions 1 November 15th 06 10:07 PM
Deleting time part of a Date, subtracting dates Shirley Munro Excel Discussion (Misc queries) 3 June 21st 06 11:58 AM
Deleting part of a cell PaolaAndrea Excel Discussion (Misc queries) 1 February 17th 06 06:51 AM


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