Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 10th 03, 05:38 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 12
Default select only certain characters from a cell.

I have a cell with something like

NT7230UNAGGLOPUMP

I want another cell to read this one but only take out the UNAGGLO bit of
it.

IE only characters 7 through 11.

I want another cell to take only the last 4 characters and thus display
PUMP.

how can I do this??

SS



  #2   Report Post  
Old December 10th 03, 05:47 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default select only certain characters from a cell.

assume your data is in cell A1

=Right(A1,4)

would display Pump

=Left(A1,6) & right(A1,4)

would take out UNAGGLO

--
Regards,
Tom Ogilvy

"SS" wrote in message
...
I have a cell with something like

NT7230UNAGGLOPUMP

I want another cell to read this one but only take out the UNAGGLO bit of
it.

IE only characters 7 through 11.

I want another cell to take only the last 4 characters and thus display
PUMP.

how can I do this??

SS




  #3   Report Post  
Old December 10th 03, 05:49 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default select only certain characters from a cell.

If you meant only display characters 7 through 11 (7,8,9,10,11 is five
characters)

=Mid(A1,7,5) but UNAGGLO is 7 characters, and this would only show UNAGG,
so you could modify it to

=Mid(A1,7,7) to display UNAGGLO

--
Regards,
Tom Ogilvy

"SS" wrote in message
...
I have a cell with something like

NT7230UNAGGLOPUMP

I want another cell to read this one but only take out the UNAGGLO bit of
it.

IE only characters 7 through 11.

I want another cell to take only the last 4 characters and thus display
PUMP.

how can I do this??

SS




  #4   Report Post  
Old December 10th 03, 06:43 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 12
Default select only certain characters from a cell.

Ta.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA: Column Select then Data Select then return to cell A1 James C[_2_] Excel Discussion (Misc queries) 3 February 1st 10 11:35 AM
convert 5 characters in a cell to 6 characters by adding a zero Helenf Excel Discussion (Misc queries) 4 May 18th 09 04:43 PM
How do you select multiple characters in a drop down list to appe. Ross Noble Excel Worksheet Functions 2 August 11th 08 11:43 PM
copy select characters from specified cells. Ron Excel Worksheet Functions 3 October 9th 06 08:40 PM
select a string of characters Did Excel Worksheet Functions 7 August 17th 05 04:24 AM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017