removing specific data from fields
 

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)

removing specific data from fields
 

Hi Splat

Something like:

=--MID(A1,26,7)

and format the formula cell with the correct format (via
FormatCellsNumber tab).

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

Hope this helps!

Richard

On 29 Jan, 06:59, "splat" wrote:
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)

removing specific data from fields
 

Thanks Richard!



On Jan 29, 10:53 am, "RichardSchollar"
wrote:
Hi Splat

Something like:

=--MID(A1,26,7)

and format the formula cell with the correct format (via
FormatCellsNumber tab).

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

Hope this helps!

Richard

On 29 Jan, 06:59, "splat" wrote:



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)- Hide quoted text -- Show quoted text -

removing specific data from fields
 

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.

--
Kevin Vaughn
www.klvaughn.com


"splat" wrote in message
ups.com...
Thanks Richard!



On Jan 29, 10:53 am, "RichardSchollar"
wrote:
Hi Splat

Something like:

=--MID(A1,26,7)

and format the formula cell with the correct format (via
FormatCellsNumber tab).

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

Hope this helps!

Richard

On 29 Jan, 06:59, "splat" wrote:



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)- Hide quoted text -- Show quoted text -