Discussion Locked

Retrieve a string of characters in the middle of line

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need help retrieving an account number out of a string of characters in excel. An example of the data in the cell is "Microsoft Shares a/c 234324g2 from NetTrade" The only information that I need is "234324g2". The length of the account is always different. Anyone have any ideas on how to do this?

1 reply

by rommel_abaya

i pasted "Microsoft Shares a/c 234324g2 from NetTrade" in A1. Go to Data->Text to Columns...select Delimited and click on "Space". You'll get the account number in a separate column...Im using Excel 2007...This depends on your data however.

This discussion is closed to new replies.