<div>
Hi,<br />
<br />
select the column and press Ctrl+H<br />
<br />
Type in find: &nbsp; &nbsp; .* &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (dot and Star only)<br />
keep replace as blank.<br />
<br />
and click on replace All.
</div>


Hi,

select the column and press Ctrl+H

Type in find:     .*               (dot and Star only)
keep replace as blank.

and click on replace All.

<div>
For Santosh's solution, copy your data to a new column first and select that new column before the Replace (Ctrl+H) if you want the tweaked data in a separate column. <br />
<br />
Thomas
</div>


For Santosh's solution, copy your data to a new column first and select that new column before the Replace (Ctrl+H) if you want the tweaked data in a separate column.

Thomas

<div>
<div class="content wysiwyg-content">
I several cell in a column I have data that reads for example:<br />
<br />
04022.xls<br />
or<br />
05123.xls<br />
or<br />
123456.xls (note six numbers before the dot)<br />
or<br />
1234.xls (note four numbers before the dot)<br />
<br />
I want to keep everything BEFORE the dot and paste it in a new column to the right of the existing column. &nbsp;How can I do this?<br />
<br />
--Steve
</div>
</div>


I several cell in a column I have data that reads for example:

04022.xls
or
05123.xls
or
123456.xls (note six numbers before the dot)
or
1234.xls (note four numbers before the dot)

I want to keep everything BEFORE the dot and paste it in a new column to the right of the existing column.  How can I do this?

--Steve

How remove all characters after a period including the period

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.