removing specific data from fields

[splat]

If you have data rows with 102 characters and from position 1 to 13
was unit number, 14 to 25 was description, 26 to 32 was price etc, how
would you pull the price out of the field and place it in it's own
column with the correct format (inserting a comma at the correct place
eg. 12,95)

 

[RichardSchollar]

Hi Splat

Something like:

=--MID(A1,26,7)

and format the formula cell with the correct format (via
Format>Cells>Number tab).

The Mid extracts 7 characters from starting position 26. The double
minus converts the string to a numeric value.

Hope this helps!

Richard

 

[splat]

Thanks Richard!

Hi Splat

Something like:

=--MID(A1,26,7)

and format the formula cell with the correct format (via
Format>Cells>Number tab).

The Mid extracts 7 characters from starting position 26. The double
minus converts the string to a numeric value.

Hope this helps!

Richard

 

[Kevin Vaughn]

Belated reply (especially since I am reading this offline) as you
already have a working solution, but this would seem to be the perfect
situation for data/text to columns and then use fixed width to seperate the
fields.