Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

Make a Space in a Cell or Delete the Prefix words

Hi Experts,

Im trying to make a space betwen a link

13.10.09\Aldershot-Chelsea-05.08.02-L.jpg

I want to make a space after " \ A" I need to get a space between the backslash and A.

If this is to difficult to do I would like to remove the 13.10.09\ leaving just the Aldershot-Chelsea-05.08.02-L.jpg alone in the cell.

Please let me know.
0
gs1uk
Asked:
gs1uk
  • 3
  • 2
  • 2
  • +1
4 Solutions
 
Eric ZwiekhorstCommented:
insert column after cells holding the JPG name
Put in the first cell after the first picture name this formula: =MID(cell holding picturename,10,30)

Kind regards

Eric
0
 
Eric ZwiekhorstCommented:
If this is not what you need please upload an example sheet so I can see what you mean...


KR

Eric
0
 
Chris BottomleyCommented:
Select the cells then press ctrl and F then type \ as the find string and \ then space in the replace with and enter

Chris
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Chris BottomleyCommented:
Sorry ctrl & H for replace!

Chris
0
 
MINDSUPERBCommented:
<If this is to difficult to do I would like to remove the 13.10.09\ leaving just the Aldershot-Chelsea-05.08.02-L.jpg alone in the cell.>

Use this formula



=RIGHT(a1,LEN(B5)-FIND("\",a1))

I assume that the value is in A1.

Sincerely,
Ed
0
 
MINDSUPERBCommented:
Sorry,

It must be =RIGHT(A1,LEN(A1)-FIND("\",A1))

Ed
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

alternatively, you can use Text to Columns with the \ sign as the delimiter. That will result in your data being split into two columns:

13.10.09  in the first column and  Aldershot-Chelsea-05.08.02-L.jpg in the second column.

Select the cells with the data, then click Data > Text to Columns > Delimited  > Other and enter a \ sign in the box next to Other > Finish

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The added bonus of the Text to Column method is that the cells contain the actual value and not a formula that just displays the value. With any formula solution, you will probably need to copy the result and use Paste Special - Values to get the actual text of the results into their own cells.
0
 
Eric ZwiekhorstCommented:
Hi Teylyn,

The Text to column is only acceptable if you don't have to do it several time a week, or maybe a day..

If the name of the picture is changing regularly it must be a formula..

Kr

Eric
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now