Erase

  • Thread starter Thread starter Jw
  • Start date Start date
J

Jw

hi, everyone

i exported the below data from daceasy,

A1 inv#123 customer name
A2 inv#143 customer name
A3 inv#156 customer name
A4 inv#157 customer name

how to remove the above cells' text (inv# and company), I just keep
inv#(123,143,156 & 157) for sorting and vlookup function.

any information or hints is very appreciated.

thanks

jimmy
 
Hi
in your case try 'Data - Text to Columns'. Choose the space as
delimiter. This way only the invoice number should remain in the first
column. Delete the other columns if you like
 
Back
Top