SteveL13
asked on
How remove all characters after a period including the period
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Thomas
select the column and press Ctrl+H
Type in find: .* (dot and Star only)
keep replace as blank.
and click on replace All.