Microsoft Office Forums - View Single Post - [Solved] Removing characters from a cell

Thread: [Solved] Removing characters from a cell

View Single Post

Old

01-10-2016, 03:16 PM

tonydoneese tonydoneese is offline

tonydoneese is offline

tonydoneese uses Windows 7 64bit

Windows 7 64bit tonydoneese uses Office 2010 64bit

tonydoneese uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jan 2016

Posts: 4

tonydoneese is on a distinguished road

Default

Removing characters from a cell

I'm trying to modify a worksheet. I used to know the formula for this but I have forgotten. I need to remove characters from a cell and place the removed characters in another cell. The example below shows that I have 25 ea in the same cell but I need 25 in its own cell and I need ea in its own cell.

Column A
25 ea

Column A Column B
25 ea

Reply With Quote