General discussion

Locked

Retrieve a string of characters in the middle of line

By pezbot ·
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?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Re:Retrieve a string of characters in the middle of line

by rommel_abaya In reply to Retrieve a string of char ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums