Required some common characters in cell

Closed
sam - Sep 3, 2011 at 03:59 AM
 Anonymous User - Sep 3, 2011 at 04:23 AM
Dear all,

I have following data in excel like this......

/OCEAN FRIGHT CHARGES INV NO 7428117730
/ OCEAN FRIGHT CHARGES INV NO. 7428116244
/ OCEAN FRIGHT CHARGES INV NO 7428112837
OCEAN FRIGHT CHARGES/INV 7428109648/31.08
0/ OCEAN FRIGHT CHARGES /INV 7428106077
0 / Export Freight 7428105627/Crane


Now , i just want Invoice No. (i.e. begin with "74-------" only 10 characters) in separate column




1 response

Anonymous User
Sep 3, 2011 at 04:23 AM
Remember ...

Before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

Say please, thank you, appreciate, grateful, regards, etc... is common practice when you want something especially help!

So re-write your message respecting the politeness charter by using these words and repost your message on the forum.

We trust that you understand.
0