Data extraction from cell in excel 2003

[Gandalf the Grey]

Data in cell A1 - 1) A Q
Data in cell A2 - 12) V
Data in cell A3 - 131) B H L

How do I throw away the #) and the following space in cells A1, A2, and A3 and save the rest?
Excel 2003 answer, please. ie. no VBA.

Thanks

 

[Weazel]

maybe something like....

=TRIM(SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)-1),""))

 

[Gandalf the Grey]

maybe something like....

=TRIM(SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)-1),""))

Weazel - You are the man. No wonder I could figure it out. Thanks.

 

[Gandalf the Grey]

[Resolved] Data extraction from cell in excel 2003

Thread resolved.

 

[Rick Rothstein]

Re: [Resolved] Data extraction from cell in excel 2003

If you are wanting to physically change your original data within the cells the data reside in, then there is a non-formula method to do that... select the column or columns of cells containing the data you want to change, press CTRL+H to bring up the Replace dialog box, type "*) " (without the quotes, so you are typing asterisk, right parenthesis, space) into the "Find what" field, leave the "Replace with" field empty, click the "Options>>" button and make sure the "Match entire cell contents" checkbox is not checked, then click the "Replace All" button.