|
|
#1
07-27-2016, 11:05 PM
|
|||
|
|||
Find & replace a character in a particuler position
How to find & replace a beginning character of a sentence/text if it matches to a particular character?
Same way how to find & replace a last character of a sentence/text if it matches to a particular character? eg in Cell A1 - (apple (a) 100) A2 - (orange 50) Here I need to replace the starting open parenthesis & ending closing parenthesis with none. A1 - apple (a) 100 A2 - orange 50 How can I do this in excel? Thanks in advance. 
|
| Tags |
| find & replace, wildcard searches |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Replace a random character with the same character
|
RickLegrand | Word | 7 | 07-23-2015 06:35 PM |
| Wildcard Find/Replace deletes extra character | Cosmo | Word | 1 | 06-20-2014 08:49 AM |
|
Help with the "find and replace" option; character problem
|
martinn4 | Word | 3 | 02-20-2014 03:52 AM |
|
character spacing position disabled
|
fogharty | Word | 2 | 07-27-2011 01:26 PM |
|
jumping to a character position in Word
|
ahha | Word | 1 | 07-23-2007 02:57 PM |
Windows 10 
Office 2016
Threaded Mode