Link to home
Start Free TrialLog in
Avatar of Yashy
YashyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel - how to take some data in one cell and have it erased, whilst leaving the rest

hi guys,

So I have some cells in Excel which I need to modify automatically rather than manually.

As an example, there is a cell let's say A1 with the content 15.55GB (16,000,0000) . However, i want to remove from the cell 15.55GB along with the brackets removed so it just leaves us with 16,000,000 in the cell?

Cheers
Yashy
ASKER CERTIFIED SOLUTION
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can use the formula I entered above into a new column, and then copy that column and paste values into the original column.
Avatar of Yashy

ASKER

Thank you for the help people.