Removing Text

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi Everyone,

Problem - Im trying to remove the last two characters (Text) from each cell.

Example:
(A1)Expense Account
(A2)Robert Smith

Result Deisred:
(A1) Expense Accou
(A2) Robert Smi

Any help would be greatly appreciated.

Thanks!
Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed length string of text 7
TEXT issues 2
Text and Value in Cell 3
Have afirst name and last name and want to seperate them. 1
Removing various combinations of text and returning only a number inexcel 6
Edit, Fill, Justify 3
Extracting number from Text and () 15
grouping with vba 1

Back
Top